Chart Title Link to Data Table

G

GasGal

I am charting the output of many meters to view on screen and need to know
how I can link the chart title to the meter name in the data in Excel 2007.
It was possible in 2003, but it seems impossible in 2007.
 
S

Shane Devenshire

Hi,

Basically the same as 2003: Single click the chart title, click on the
Formula Bar and type = then click on the cell containing the meter name and
press Enter.

The chart title will be picked up from the spreadsheet, for example the
formula bar might read ='Pie Chart'!$B$1
 

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

Create a chart from a table in word thats dynamic 0
Filtered view of Visio Chart 0
Doughnut Chart linked with the slicer in the pivot table 0
Chart SERIES OFFSET 5
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Creating a Chart on form from selected data in query. 0
Creating a Search using a combo box and then creating a report. 4
Save a custom chart as a template 0

Top