Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately.
When you add titles to a chart, whether it's the main title or any other titles on the left-hand side of the plot area, or below the plot area, instead of typing the various titles that you need, you can link chart titles directly to specific worksheet cells. Maybe for the main title on this particular chart we want to use the title that we see in cell A1. It's a centered entry that says 'Two Trees Olive Oil Company'. So let's suppose we want to add a title here. Chart Title on the Layout tab, we'll click the option and choose Centered Overlay Title like this. And at this point simply type equal--and you'll see this in the formula bar, by the way--click on cell A1 or anywhere on the panel up there since that's a centered title-- click here, for example--and simply press Enter, and the title goes right into place there.
Similarly with other titles that we might need. We need to explain what these numbers are; someone's looking at the chart only. So similarly, on the Layout tab in the Ribbon, we'll choose Axis Titles > the Primary Vertical Axis Title, perhaps rotated. That's the most appropriate one here. And similarly, equal, and this time we'll click on cell A2 to pick up that information and simply press Enter, and we see what's happening here. So that's a good quick fix in both examples for getting titles into charts without to having to use any typing whatsoever.
Now I'm going to press Ctrl+Z a couple of times to take out these titles and remind you that also you can create titles from the Design tab by choosing one of the chart layout options that contain titles. So, for example, this choice has a main title. This one has a main title and a title on the left. Perhaps, we'll go with this one. It has some other features as well. So if you were to choose this option, you would have the same situation. So how do we add the chart titles this way using the technique just demonstrated? This time simply click near or on Chart Title and type =, click cell A1, Enter, and we see the title appear there.
Similarly, on the left-hand side, click Axis Titles, type =, click on cell A2, and press Enter, and we have the entries going in this way. That one probably needs to be dragged around a bit to be adjusted, but the main idea here of course is we don't type the entries, we simply pick them up from cell references. So you can save a good deal of typing time and improve accuracy by linking titles to worksheet cells.
There are currently no FAQs about Excel 2007: Charts in Depth.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.