Linking Graph Textboxes to Cells

[Barron]

Using Excel 97.

I want to have a Graph title (for example) be populated by the data in a cell on the worksheet. I'm using vlookups to keep data current in the cells, but I want to chart to also stay current.

Thanks
Barron

 

[Russell Hauf]

Click on the chart title. In the name box, you should see "Chart Title". In the formula bar, type the reference to the cell you want to link to. For example:

=Sheet1!A1

Hope this helps!

-rh

 

[Barron]

Perfect! Thank you very, very much!!

Barron