Importing text to chart based on link to cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stephen - 07 Nov 2003 20:59 GMT

I am attempting to link a cell from my spread sheet to a
text box in my chart, but have been unable to do so. Does
anyone know how or if this is possible.

Reply to this Message

dvt - 07 Nov 2003 22:00 GMT

> I am attempting to link a cell from my spread sheet to a
> text box in my chart, but have been unable to do so. Does
> anyone know how or if this is possible.

Select the chart, then click in the formula bar (above the chart, next to
the little "fx"), type the equal sign, then click on the cell that you
wish to reference. A formula like =Sheet1!A1 should appear in the formula
bar. Hit enter and you should have the dynamic text box on your chart.
Move and format as desired.

Signature

Dave
dvt at psu dot edu

Reply to this Message

Jon Peltier - 08 Nov 2003 05:07 GMT

>> I am attempting to link a cell from my spread sheet to a
>> text box in my chart, but have been unable to do so. Does
>> anyone know how or if this is possible.

> Select the chart, then click in the formula bar (above the chart, next
> to the little "fx"), type the equal sign, then click on the cell that
> you wish to reference. A formula like =Sheet1!A1 should appear in the
> formula bar. Hit enter and you should have the dynamic text box on your
> chart. Move and format as desired.

This also works with axis titles, chart titles, and data labels. Select
the individual text element to be linked (two single clicks, not a
double click, for a data label), type =, then click in the target cell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Reply to this Message