Linking titles to content


show more Linking titles to content provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth show less
please wait ...

Linking titles to content

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 simila...

Linking titles to content
Video duration: 2m 32s 3h 36m Intermediate

Viewers:

Linking titles to content provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...