Updating Chart Titles from Spreadsheet Cells

  • Thread starter Thread starter karloff
  • Start date Start date
K

karloff

I'm using Excel 2002 and I want to be able to have the titles in my
charts update based on entries in the associated spreadsheet. On a
monthly basis I import data into a spreadsheet template that has a
chart associated with it. It would be nice if the title block on the
chart would update based on a cell in the spreadsheet.
 
Hi karloff,

You can link the charttitle to a cell.

Select the charttitle and then in the formula bar type = and then click
the cell.
I'm using Excel 2002 and I want to be able to have the titles in my
charts update based on entries in the associated spreadsheet. On a
monthly basis I import data into a spreadsheet template that has a
chart associated with it. It would be nice if the title block on the
chart would update based on a cell in the spreadsheet.
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
-----Original Message-----
I'm using Excel 2002 and I want to be able to have the titles in my
charts update based on entries in the associated spreadsheet. On a
monthly basis I import data into a spreadsheet template that has a
chart associated with it. It would be nice if the title block on the
chart would update based on a cell in the spreadsheet.
Click to expand...
right click the title on the chart then in the "formula
bar" enter =(your cell ref) eg =AE53.

Mike G
 
You need to enter the sheet ref before the cell ref:

=Sheet1!AE53

or type = and click on the cell with the mouse.

- Jon
 
Back
Top