Dynamic Text on a Chart

  • Thread starter Thread starter Jeff K.
  • Start date Start date
J

Jeff K.

I have a line of text on a chart that gives the N that
the averages were calculated with for the chart. It
looks like this:

Title Text (Placed by the wizard)
N = 18 (Placed manually)

I would like to have the value (18) be dynamically
displayed according to the cell value used in the
worksheet for the actual calculations. This would save
me from changing the chart(s) manually if the N ever
changes on the worksheet. Is it possible? I tried to
write a formula in the chart itself to concatenate("N
= ",WorksheetCellAddress) but Excel did not like that.
 
Select the chart. Type = Use the mouse and click in the cell
containing the number. XL will insert a textbox in the chart with a
link to the cell.

For more details see
Dynamic Chart Title
http://www.tushar-
mehta.com/excel/newsgroups/dynamic_chart_title/index.html

The same concept applies to a datalabel or a textbox within a chart.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
To make a customized label, build the formula in the cell that you link to.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top