Importing text to chart based on link to cell

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

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.
 
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.
Click to expand...

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.
 
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.
Click to expand...

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
 
Back
Top