Join Dennis Taylor for an in-depth discussion in this video Work with chart and axes titles, part of Excel: Charts in Depth.
- [Instructor] When you create a chart quickly in Excel … one of the first things you're likely to do … is to change the chart title. … I'm highlighting some data from cells A3 over … and down through G6. … I'll press the keystroke shortcut Alt + F1 … to create a chart. … And there's Chart Title and I'll just type in the title … maybe 1st Half 2020. … We don't see the title just yet … unless you're looking in the formula bar where it appears. … Press Enter. … We've got our title. … And often that's the approach to take, … but sometimes you get data from other sources. … Let's say, the chart to the right … doesn't have a title on it, or maybe you took it off, … but the point is you can add it easily. … Couple different ways to do it. … The fastest way often is, once a chart is selected, … take a look at some of the options … available on the Chart Design tab, … off to the left, under Quick Layout. … With the column chart, … you'll have nine different choices here. … Most of these have a bar across the top …
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 and axes titles