Outlier data point for Chart in Excel

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

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?
 
One option is to use a log scale.

Another is to move the outlier to the secondary axis.

Yet another is to simulate a break in the axis. See
Broken axis
http://www.tushar-mehta.com/excel/newsgroups/broken_y_axis/tutorial/

or Jon Peltier's http://peltiertech.com/Excel/Charts/BrokenYAxis.html or
Andy Pope's http://andypope.info/charts/brokencolumn.htm

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu
 
Back
Top