You might want to rotate text either to accommodate more explanatory text or…possibly to improve readability.…Here too, a feature that is not going to be reached by going to the Format tab…and choosing any of the options there.…Best way to get to slanting text capability is simply to go to the Home tab in the Ribbon.…In other words, we're using features that are available outside the realm of charting.…It's strongly advisable not to tilt your main title but if you want to go there,…that's available and it is acceptable.…
The Angle Text option here under Alignment, you can certainly do that if you wanted to.…Maybe here and there for special effects with shorter words.…It might make some sense.…Now if you click on the legend you'll see immediately that box is unselectable.…And probably with a good reason.…Who would want a slanted legend?…If you try this on the left-hand side here on this text, you could go down that way too.…What about at the bottom here?…This is a more likely use of this, underneath the columns here.…
Author
Released
6/15/2011- Identifying the plot area, chart area, gridlines, legends, and more
- Selecting the right chart type
- Creating charts instantly with shortcuts
- Choosing a layout
- Dealing with empty and hidden cells
- Switching rows and columns for a different view of the data
- Moving and resizing a chart
- Inserting pictures and shapes
- Adding labels to a chart
- Analyzing existing and future data with trendlines
- Changing a chart's data source
- Printing charts
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel 2010: Pivot Tables
with Curt Frye3h 43m Intermediate -
Managing and Analyzing Data in Excel 2010
with Dennis Taylor1h 32m Intermediate
-
Introduction
-
Welcome1m
-
-
1. Understanding Excel Chart Concepts
-
2. Creating Basic Charts Quickly
-
3. Fine-Tuning Charts with Design Tab Choices
-
Choosing a chart layout3m 22s
-
4. Layout Tab Options: Inserting Pictures, Shapes, and Text Boxes
-
Adding shapes and arrows2m 58s
-
5. Layout Tab Options: Adding Titles, Labels, and Legends
-
Linking titles to content1m 52s
-
6. Layout Tab Options: Using Axes and Gridlines
-
Modifying axis scaling7m 55s
-
Working with gridlines4m 11s
-
-
7. Layout Tab Options: Using the Analysis Tools
-
Adding drop lines1m 11s
-
Adding error bars4m 34s
-
8. Format Tab Options: Adding Shapes and WordArt Styles
-
Adding shape effects5m 34s
-
Applying WordArt styles2m 1s
-
9. Using Other Formatting Tools
-
Formatting lines and borders3m 45s
-
Working with chart text2m 47s
-
-
10. Adjusting Specific Chart Types
-
Using column and bar charts9m 12s
-
Using line charts5m 25s
-
Using pie charts6m 30s
-
-
11. Changing a Chart's Data Source
-
12. Printing and Sharing Charts
-
Printing charts6m 41s
-
-
Conclusion
-
Next steps43s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Changing the rotation of chart text