Skip to Content
author's profile photo Nina Sa
0
Nina Sa

Some of the data values not displayed on the bar chart

Posted on Jul 13, 2020 at 07:25 PM 36 Views

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!

data-value-not-displayed.jpg (37.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo M Mohammed
    M Mohammed
    Posted on Jul 14, 2020 at 02:51 PM
    0

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.