Share via

Excel Chart indicate wrong data

家倩 羅 1 Reputation point
2021-03-24T08:48:36.997+00:00

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]: /api/attachments/81132-data-indication.png?platform=QnA

Microsoft 365 and Office | Excel | For business | Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 30,126 Reputation points Microsoft External Staff
    2021-03-25T07:21:38.143+00:00

    Hi @家倩 羅 ,
    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.

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.