View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Chris Chris is offline
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?