Showing only top bars
Sometimes only the highest bars are of interest in a bar chart. In these cases, you can select how many of the highest bars to display and let the other bars be hidden.
Place the cursor on the
Category axis in the bar chart.
The axis is highlighted.
Click the highlighted area to access a pop-up menu.
- In the Show only the top field, type how many bars to display, and press Enter.
ExampleIn this bar chart that shows test results for a number of individuals, more than one bar show the same value.
If 5 is specified in the Show only the top field, the resulting bar chart will display six bars as shown below. The reason is that, on the fifth place, there are two bars, John and Robert, with identical values.
Showing only top bar segments
If the bars in the bar chart are split into segments, the Show only the top setting is applied to the segments and not the entire bars.