question

62437149 avatar image
0 Votes"
62437149 asked emizhang-msft commented

Excel Chart indicate wrong data

Why parts of the data indication are wrong and parts ![81132-data-indication.png][1]are right when we move the mouse to certain point. (As the picture attached) [1]: /answers/storage/attachments/81132-data-indication.png

office-excel-itpro
data-indication.png (906.0 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @62437149,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

0 Votes 0 ·

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered

Hi @62437149,
Did you create the PivotChart?
I suggest you go to Pivot Table and check the Value number format, make sure the Decimal places is 2:

81473-165.gif

If my understanding is incorrect, please provide more information and I'm glad to help you.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.





165.gif (324.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.