outliers in charts

[Tuxla]

I have created a simple bar chart, but I have a few outliers that skew the
layout of the chart.

for example:
a = 2
b = 3
c = 78
d = 2
e = 1
f = 3
g = 150 etc

I still need to include "c" and "g", but because I have a lot of data it
makes the rest of the bars so low you can't tell accurately what they are.

I have tried to change the scale with the intention of having a data label
on the out-liers, but that doesn't work as I could only make the data label
show on all bars (which I don't want) and it only shows at the top of the bar
so the outliers still don't show a value.

Does anyone have any ideas, please?

Thank you

 

[ShaneDevenshire]

Hi,

If data labels would work - you can add them to individual points by 1.
clicking the series once, then clicking the data point once, then choosing
Format, Selected Data Point, ...

 

[Jon Peltier]

You could try this approach, which will work just as well on a column chart:

http://peltiertech.com/Excel/ChartsHowTo/OutlierLabels.html

- Jon

 

[Tuxla]

Thank you both

You could try this approach, which will work just as well on a column chart:

http://peltiertech.com/Excel/ChartsHowTo/OutlierLabels.html

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