Presenting data in a pivot-chart

**vvexcel** · 09-16-2023, 11:46 PM

Hi,
I'm building a report to track mix shift in each month across multiple years. But I'm having trouble make it to work. see the attached the image for what i'd like to present. The category data is not always dichotomous, so i'd like to maintain it in a pivot chart. I don't want to see the absolute sold count, instead, i'd like to see the mix shift in each year/month by category. I've tried multiple ways like show value as % of parent total, etc., and can't figure it out.
here is the expected result.
expected.PNG

Thank you!

**JeteMc** · 09-18-2023, 01:20 PM

Hello vvexcel and Welcome to Excel Forum.
In the file attached to post #1, it seems that the values in cells D59:D70 should be the sold count instead of percentages.
I am also not sure what you mean by % of parent total although it seems that it means the percentage of detail 0 in month 1 of 2021 divided by the sum of details 1 and 0 in month 1 of 2021.
If that is the case then perhaps adding a column (E) to the data in columns A:D using the following will help:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

**vvexcel** · 09-18-2023, 01:55 PM

Hi JeteMC, thanks for responding to my question. Your approach fixed my question, I appreciate your help!

**JeteMc** · 09-18-2023, 07:02 PM

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.

Presenting data in a pivot-chart

LinkBack

Thread Tools

Rate This Thread

Display

Presenting data in a pivot-chart

Re: Presenting data in a pivot-chart

Re: Presenting data in a pivot-chart

Re: Presenting data in a pivot-chart

Thread Information

Users Browsing this Thread

Similar Threads

Presenting bimodals in bar chart

in what kind of circumstances is more efficient to use a pivot table when presenting info?

Presenting and printing a payroll pivot table

Pivot Table Presenting Data

Multiply a series values 'on the fly' before presenting in chart.

Presenting Data

presenting lots of data in a chart & table

Bookmarks

Bookmarks

Posting Permissions