Linking Graph Textboxes to Cells

Barron · Mar 27th, 2002, 03:12 PM

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 · Mar 27th, 2002, 05:07 PM

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 · Mar 27th, 2002, 05:15 PM

Perfect! Thank you very, very much!!

Barron

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 03:12 PM	#1
Barron New Member Join Date: Mar 2002 Posts: 2	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

Mar 27th, 2002, 05:07 PM	#2
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	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

Mar 27th, 2002, 05:15 PM	#3
Barron New Member Join Date: Mar 2002 Posts: 2	Perfect! Thank you very, very much!! Barron