Share via

Excel Pivot table Chart

Flinn, Randal J 281 Reputation points
2021-12-07T15:52:35.967+00:00

Hello,

I have pivot table/chart below; however, the data in the red "oval" is not displaying on the chart. My thought was to include on the chart on a secondary axis. Why would this not display?

155668-image.png

Thanks

Microsoft 365 and Office Development Other
Microsoft 365 and Office Excel For business Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,796 Reputation points
    2021-12-08T08:21:10.963+00:00

    Hi @Flinn, Randal J

    I created a Power Pivot Table based on your another thread "Calculation of Percentages in Pivot with Distinct Count", and I could not reproduce your issue.

    Could you pleae right-click on this chart > Change Chart Type > Combo, then please take a screenshot of your settings like following image?
    Please make sure the series of your "Total Distinct Count of" is shown on this interface, and you could tick the box of "Secondary Axis".
    155922-capture27.jpg

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    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.

    1 person found this answer helpful.

Your answer

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