Dynamic Title on Chart

D

Doug Akers

I would like to have the title of a chart change based on
a specific cell on the spreadsheet. Any suggestions?
 
J

Jon Peltier

Even easier than typing the cell reference:

Select the chart title
Type =
Select the cell with the mouse

Also works with axis titles and data labels.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Re-title multiple MS Project .mpp files at once 0
Creating a Chart on form from selected data in query. 0
Space at end of multi page list to accommodate new entries 1
Move Chart with Text 0
Dynamic Chart title and text formula? 1
Dynamic Chart Title With 3D Stacked Column Chart 2
Loss of referenced data (Titles) when upgrading from Excel 2000 to2007 1
Displaying content of a cell somewhere on the chart 1

Top