Share via

Excel 2016 / Chart Data Table number formats

Anonymous
2016-04-12T07:45:45+00:00

Customer of ours is having difficulties with Excel chart formats. 

So here is the first screenshots from the actual data:

The cell highlighted contains actual data of 82477 but has a custom format set. So we would like the chart also show these custom formatted numbers, but instead it takes the original data (82477). And this is only so with Office 2016 and Office 2013. With 2010 it works like this. Any of You could clear this up for me?

Excel 2010 (correct):

Excel 2013 (not correct):

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2016-04-13T13:58:33+00:00

    Hi,

    Let us use the format of 0.0, (Including the “,”). The data will display correctly.

    Hope this information helps you. Please let us know if you need additional information.

    Thank you.

    0 comments
  3. Anonymous
    2016-04-19T06:18:32+00:00

    Unfortunately its not working.

    0 comments
  4. Ashish Mathur 100.9K Reputation points Volunteer Moderator
    2016-04-20T00:16:59+00:00

    Hi,

    Try this format 0.0;

    0 comments
  5. Anonymous
    2016-04-20T05:16:01+00:00

    No luck

    0 comments