displaying descriptive stats on a chart

  • Thread starter Thread starter jcl9684
  • Start date Start date
J

jcl9684

Thanks to the forum for the suggestion about the INDIRECT() function, i
solved the problem nicely.

One more question, this time about charts. I can't seem to find a wa
to display relevant information in something like an info-box on
chart. I'm looking for a way to display the min value, max value
standard deviation, and latest value of each data series. Ideally
these numbers would be labelled in a box similar to the "legend" box.
How can one do this?

Any ideas or solutions would be a great help to a relative novice Exce
user. Thanks

Jak
 
Also, the descriptive stats need to be able to auto update -- currently
i'm just using formulas within cells to generate the data, but I'd lik
to have the data on a graph
 
Hi,

You could add a textbox to the chart and link its contents to the cell.
To add a text box simply select the chart then type =
now select the cell. When you press return it should create a textbox
embedded in the chart. Position as required.

Cheers
Andy
 
Back
Top