LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 12
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find outliers Steve Excel Discussion (Misc queries) 1 August 20th 08 02:48 PM
how to calculate outliers ismhs Charts and Charting in Excel 1 June 1st 08 02:49 PM
Identifying Outliers Quco Excel Discussion (Misc queries) 13 February 14th 07 06:32 PM
Boxplots with outliers Confuzzled. Charts and Charting in Excel 1 March 17th 06 07:36 PM
outliers/histograms Julie Excel Discussion (Misc queries) 1 January 14th 06 07:28 AM


All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"