Some of the data values not displayed on the bar chart

[former_member611722]

data-value-not-displayed.jpg

Hi,

Can someone please tell me how can I have all data values displayed on the chart? why some of them are missing here?

Also, how can I adjust the height and width automatically based on the content?

Your help is appreciated!

[mhmohammed · Accepted solution]

Hi Nina,

Make the following changes by Right Click on Chart -> Format Chart ->

1. Global -> Data Values -> Data Position -> Outside
2. Global -> Data Values -> Orientation -> Horizontal
3. Global -> Palette and Style -> Marker -> Check All Markers
4. Click Apply and OK

Also, I found this issue to be resolved only if we increase the height & width of Chart. Let us know if the above works.

You cannot adjust the height and width of the Chart automatically depending on the amount of content/data in it. One workaround would be to create a copy of the 1st Chart, and update the height and width of the copy/2nd Chart to to make it bigger and conditionally show/hide both the Charts depending on the amount of content/data in it.

Thanks,
Mahboob Mohammed