displaying stats on a chart

[jcl9684]

<mistakenly posted earlier in another forum, my apologies>

I would like to display relevant descriptive statistics with labels i
the top right hand corner of an XY chart. The chart is listin
financial data (think stock prices over the last 10 years), and I wan
to display the min, max, average, stdev, and last value.

Thanks in advance,
Jak

 

[alicia]

Do you use Excel's descip. statistics generator from the
Data analysis add-in tool?

 

[jcl9684]

the descriptive stats on data analysis is a great way to generate th
data.

However, it only makes the data availible within spreadsheet cells --
am looking for a way to transfer that data onto the Chart itself, an
the descriptive stats also need to automatically update. I'm usin
functions to generate the stats in cells currently because the dat
analysis tool doesnt auto update

 

[Debra Dalgleish]

You can calculate the values on the worksheet, then use the Camera tool
to paste a picture of the cells onto the chart.

To add the camera tool to your toolbar, choose Tools>Customize
On the Commands tab, select the Tools category
Scroll through the tools to find the camera, and drag it onto
one of your existing toolbars
Close the Customize dialog box

Select the cells that contain the statistics.
Click the Camera button
Select the chart sheet
Click, to paste the picture