Chart Value Labels have 3 Decimal Places, Source Data has 2?

Question

Bardonicloud Author

Level 1

51 points

Chart Value Labels have 3 Decimal Places, Source Data has 2?

I'm trying to figure why I have 3 decimal places on the red lines on this chart when the source data has 2?

Cheers,

MacBook Pro 15″, macOS 12.3

Posted on Sep 14, 2023 3:05 AM

Reply

Answer 1

Recycleur

Level 4

1,741 points

Oct 13, 2023 7:13 AM in response to Bardonicloud

In another thread I think you mentioned that this was originally an Excel file. If so it appears this is another glitch in the conversion process.

To fix it it might be faster to modify the source data by surrounding each formula by a ROUND(current formula,2). Beware that if the rounded values are used in other formulas the rounding may produce slightly different results for them.

You change the formula in one cell (or at worst the four cells on the first row) and copy-drag to change all others. If the current formula only refers to data in the same table you can also copy the formula to all other sheets, it won't keep the reference to the original table as was a problem reported in another of your threads.

Reply

Answer 2

Ralf-F

Level 4

2,777 points

Sep 14, 2023 4:45 AM in response to Bardonicloud

Please check the format of you data.

Often the format is set to display only 2 decimals, even the real data have more decimals.

To change the format in you graph you can select the value and change the number of decimals to 2.

Regards Ralf

Reply

Answer 3

Bardonicloud Author

Level 1

51 points

Oct 13, 2023 4:51 AM in response to Ralf-F

Hi Ralf

The tables are all set to Number format with 2 decimal Places (dp). The charts are set to "Same as Source Data."

I just can't figure out why it's not displaying correctly?

If I can't fix it I will have to edit 30 plus charts individually as I didn't notice the 3 dp when I copy and pasted them to other sheets - some charts have 4 lines each and value labels!

Any solution would be gratefully appreciated,

Thanks,

Ps/ Do you know when the "My Subscriptions" error in the forums that people have mentioned (I too can't see all the topics I've posted on here) will be fixed?

Reply

Answer 4

Bardonicloud Author

Level 1

51 points

Dec 6, 2023 11:42 AM in response to Recycleur

Hi @Recycleur,

Btw, I posted a topic about some charts with a curved price line that were not showing all the value labels, there were gaps in the values and I drew a graphic with large red arrows pointing to the missing values.

Someone replied, I think it might have been you but I cannot find it in My Subscriptions?

Is there still an issue with My Subscriptions as reported a month or so back by one of the forum mods?

The chart may have had a cream background - here is a similar chart with missing value labels:

Thanks again for all your help, present and past 👍

Reply

Answer 5

Recycleur

Level 4

1,741 points

Dec 6, 2023 12:33 PM in response to Bardonicloud

This was the message: Chart Missing some Value Labels - Apple Community

Reply

Answer 6

Bardonicloud Author

Level 1

51 points

Dec 8, 2023 3:42 AM in response to Recycleur

Thanks for this! This particular post is no longer in my Subscriptions though, any ideas why? Cheers.

Reply

Chart Value Labels have 3 Decimal Places, Source Data has 2?

Similar questions