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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
outliers in charts
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, ... -- Cheers, Shane Devenshire "Tuxla" wrote: 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
outliers in charts
You could try this approach, which will work just as well on a column chart:
http://peltiertech.com/Excel/ChartsH...ierLabels.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tuxla" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
outliers in charts
Thank you both
"Jon Peltier" wrote: You could try this approach, which will work just as well on a column chart: http://peltiertech.com/Excel/ChartsH...ierLabels.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Tuxla" wrote in message ... 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 |
Reply |
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) |