Display significance in charts

[heather.prabish]

Hello,

I have a number of bar charts and I need to show which
points are statistcially significant to the others without
manual manipulation of data labels or bar chart colors.
Is there anyway for me to automatically show
significance? I'm looking for some way to either have
both number and text in my data sheet or for my numbers to
be colored in the data portion and also charted that color
automatically.

Any ideas would be appreciated.

Thanks!

 

[Jon Peltier]

Heather -

You could use Rob Bovey's Chart Labeler to automatically manipulate the
data labels (it's free at http://appspro.com). Or you could try making
a conditional chart:

http://www.geocities.com/jonpeltier/Excel/Charts/ConditionalChart1.html

- Jon