Join Dennis Taylor for an in-depth discussion in this video Work with chart text, part of Excel: Charts in Depth.
- [Man] On this worksheet called chart text … in our chapter four exercise file, … I think most of us, upon seeing this chart, … would say the fonts are way too big across the bottom. … Also on the left hand side. … We can individually click each one of these … and make a change. … But not so well known is the idea … that we can change all the major titles at once … on a chart simply by clicking in the chart area. … That's the perimeter area on the chart. … I'll click chart area. … And then, on the home tab, there's the font size here. … Click the drop arrow. … And as I slide over the numbers, … look at all the titles, … both above and below, … on the left and right side of the chart. … The legend on the right, and so on. … All these are changing at once. … Suppose we start off with 12. … That's pretty good for most of them. … And while we're here, … we could be making these bold. … There's also the numbers down the left hand side … on the vertical axis, become bold. … We could make them italic if we wish, …
Author
Released
9/26/2019- Chart essentials
- Fine-tuning charts with design tab choices
- Inserting pictures, shapes, and text boxes
- Adding shape effects
- Applying WordArt styles
- Working with chart text
- Changing the rotation of chart text
- Changing a chart's data source
- Printing and sharing charts
- In-cell chart alternatives
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel: Advanced Formulas and Functions
with Dennis Taylor4h 35m Intermediate
-
Introduction
-
1. Chart Essentials
-
Overview of chart types3m 11s
-
Choose styles and layouts3m 42s
-
Change chart orientation3m 26s
-
2. Fine-Tune Your Charts
-
Add a chart element2m 31s
-
-
3. Adjust Chart Elements
-
Modify axes3m 22s
-
Link titles to content2m 59s
-
Add and edit data labels3m 28s
-
Add a data table3m 9s
-
Work with gridlines3m 19s
-
Use legends3m 22s
-
-
4. Format Tab Options
-
Work with shapes and arrows2m 56s
-
Add shape styles and effects3m 31s
-
Work with chart text2m 53s
-
Apply WordArt styles2m 5s
-
5. Work with Popular Chart Types
-
Column and bar charts3m 16s
-
Line and area charts3m 25s
-
-
6. Other Specialized Excel Charts
-
Combination charts3m 23s
-
Stock charts3m 30s
-
Scatter charts3m 30s
-
Bubble charts3m 27s
-
Radar charts3m 26s
-
Gantt charts3m 31s
-
-
7. New Excel Chart Types
-
Overview of new chart types2m 23s
-
TreeMap charts3m 24s
-
Sunburst charts1m 51s
-
Histogram chart3m 18s
-
Box and whisker chart3m 30s
-
Pareto chart2m 21s
-
Waterfall and funnel charts4m 19s
-
-
8. Change a Chart's Data Source
-
9. Print and Share Charts
-
Print charts3m 48s
-
-
10. In-Cell Chart Alternatives
-
Conclusion
-
Next steps25s
-
- 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: Work with chart text