Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
outliers in charts
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find outliers | Excel Discussion (Misc queries) | |||
how to calculate outliers | Charts and Charting in Excel | |||
Identifying Outliers | Excel Discussion (Misc queries) | |||
Boxplots with outliers | Charts and Charting in Excel | |||
outliers/histograms | Excel Discussion (Misc queries) |