View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default 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.