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: 788
Default Outlier data point for Chart in Excel

I have created a bar graph with 5 bars. One of the data points has a
disproportionately high value, and it is hard to view the other data points
in the chart because their value is so low.

If I fix the axis to a lower value, the data point label for the large value
will only show up on the graph if I center it. If I try to move the label,
it disappears.

This is hard to explain, but in other graphs I have seen similar outliers
represented as a bar with a zigzag near the end and a data label.

Is there a way to format a chart so it can properly represent the outlier,
without having to make the axis long enough to include the whole bar?
 
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
Moving a line chart data point revises data table value in Excel ' Ed Smith Charts and Charting in Excel 2 November 16th 12 01:03 PM
Formatting Data point in Bar Chart Athena[_2_] Charts and Charting in Excel 1 January 30th 09 05:28 PM
chart formatted data point Pippa M Charts and Charting in Excel 1 September 4th 08 01:25 PM
How do I add a comment to a data point in a chart? erin_taylor Charts and Charting in Excel 2 June 14th 06 08:52 PM
How to remove a data point in a chart? Vicky Charts and Charting in Excel 6 July 15th 05 05:27 PM


All times are GMT +1. The time now is 06:04 AM.

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

About Us

"It's about Microsoft Excel"