topic Re: Missing total label on some bars in bar chart in Visualization and Usability

Missing total label on some bars in bar chart

blipblopdk — Mon, 11 May 2020 06:00:57 GMT

I have attached a picture of a bar chart where I have activated total labels, but total is not shown on two of the bars, the highest ones (but on all others). The total value in those two bars are below 60.000. I have set the range for the Y-axis to Auto. If I change it to manual and select Min/Max with 0 and 60.000, the total of these two bars STILL do not show. If I set Max to 70.000, the total DOES show on these two bars. I am a little puzzled about this behaviour.

Re: Missing total label on some bars in bar chart

Andrew_Roy — Wed, 29 Jun 2022 20:02:37 GMT

The total label not displaying is expected behavior when the chart doesn't have enough space. There is a workaround. As a test, if you create a new sheet, and change the Grid spacing on the sheet to Narrow (from the default Wide), charts can be resized by a relatively small amount. When you copy your bar chart to this sheet and resize by 1 grid square, the total label on the tallest bars will likely return. Depending on the range settings and how the bars grow, you might need additional chart space on the grid.