If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|