Instead of typing say a main title or any other title on this particular chart,…you can link a chart title directly to cells in the worksheet.…Let's imagine here that the main chart title here might as well be the same data…that we see in that cell A1, Two Trees Olive Oil Company.…That's a merged cell but that's okay.…So how do we add a title?…After selecting the Chart, Layout tab, in the Labels group Chart Title, how…about a title above the chart, and there we see the text.…
Now without actually clicking in the formula bar, watch what happens as I type…equal and you see the equal sign in the formula bar.…And now I'm going to click on cell A1 and simply press Enter, and so that data…is about to appear as the chart title.…There it is right there.…And in similar fashion, I might want to put in a title for the Primary…Vertical Axis here.…So on the Axis Titles button in that Labels group on the Layout tab, Primary…Vertical Axis Title, Rotated Title, this time equal, click on cell A2, and press Enter.…
Author
Dennis Taylor
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
-
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
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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: Linking titles to content