Chart Title Link to Data Table
 

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.

Chart Title Link to Data Table
 

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"GasGal" wrote:

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.