Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
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.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 64651 Viewers
80 Video lessons · 124285 Viewers
52 Video lessons · 60227 Viewers
59 Video lessons · 46062 Viewers