Paste cell value onto chart

[LeAnne]

Howdy all,

I am creating Normal Probability plots to test normality assumptions and
compare variances of two independent datasets. If the plotted data
approximate a straight (diagonal) line, the data can be assumed to be
normally distributed; and if the two plots are parallel, they can be
assumed to have equal variances. I would like to add one additional bit
of information to the finished chart, comparison of the Standard
Deviation estimates from the two datasets (if larger SD/smaller SD is
approximately >=3, then the SD's are probably "too different," and
assuming equal variances is unwarranted). On my worksheet with the QQ
calcs I have a (slightly snarky) formula that calculates the SD Ratio
(=IF(STDEV(A1:A144)>STDEV(F1:F75),STDEV(A1:A144)/STDEV(F1:F75),STDEV(F1:F75)/STDEV(A1:A144))).
I would like to "paste" the value returned by this formula into my
chart, preferably in the lower right hand corner. Paste Special only
seems to work for series, not individual cells. And I'd prefer to avoid
having to insert Word Art into the chart and typing the SD ratio in
manually, since I have many, many more QQ plots to do. Any suggestions
would be greatly appreciated.

tia,

LeAnne

PS. Using XL97, WIN98

 

[Andy Pope]

Hi LeAnne,

You could add a textbox to the chart and link it to the cell containing
the SD Ratio.
Simply select the chart and type in the cell reference, including equals
and sheet reference. eg: assume formula in cell B3 type,

=sheet1!b3

This will create the textbox for you. You can then position it where you
want within the chart.

Or maybe instead of an additional textbox you could use the charts X or
Y axis title, assuming that they are not already in use.

So, use the chart options dialog to add the x axis title. Select the
title and the once again enter the cell reference.

Howdy all,

I am creating Normal Probability plots to test normality assumptions and
compare variances of two independent datasets. If the plotted data
approximate a straight (diagonal) line, the data can be assumed to be
normally distributed; and if the two plots are parallel, they can be
assumed to have equal variances. I would like to add one additional bit
of information to the finished chart, comparison of the Standard
Deviation estimates from the two datasets (if larger SD/smaller SD is
approximately >=3, then the SD's are probably "too different," and
assuming equal variances is unwarranted). On my worksheet with the QQ
calcs I have a (slightly snarky) formula that calculates the SD Ratio
(=IF(STDEV(A1:A144)>STDEV(F1:F75),STDEV(A1:A144)/STDEV(F1:F75),STDEV(F1:F75)/STDEV(A1:A144))).
I would like to "paste" the value returned by this formula into my
chart, preferably in the lower right hand corner. Paste Special only
seems to work for series, not individual cells. And I'd prefer to avoid
having to insert Word Art into the chart and typing the SD ratio in
manually, since I have many, many more QQ plots to do. Any suggestions
would be greatly appreciated.

tia,

LeAnne

PS. Using XL97, WIN98

--

Cheers
Andy

http://www.andypope.info

 

[Jon Peltier]

An even easier way to make a textbox is to select the chart, press =,
and click on the cell. To link a chart or axis title or data label to a
cell, select the title or label, press =, and click on the cell.

- Jon