Share via

Excel Pivot Chart: include subtotal

Anonymous
2019-06-27T00:02:05+00:00

Hi,

The pivot table has 2 columns: Level 1 and Level 2. It has 1 Values.

When I create the Pivot Chart, ideally, I'd want to see the following in the bar chart.

For level 1, each has its own column

For level 2, it's a stacked column

When I choose combo chart, looks level 1 and level 2 must be of the same type.

Is this possible?

If not, is there a work-around?

Thanks

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2019-06-27T03:33:44+00:00

    Hi redhonker

    I am Vijay, an Independent Advisor. I am here to work with you on this problem.

    Can you please post a screenshot of your pivot without any confidential / sensitive data? Make sure that your row numbers and column letters are visible in the screenshot. This would help us to understand your problem better and come up with a solution.

    Was this answer helpful?

    0 comments