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?
|