Pivot Chart Issue - Custom Combination type changing when filtering with Slicers

Question

Hello,

I have an issue when plotting in a Pivot Chart some data I would like to display using a Custom Combination chart (see below picture of the chart type)

The problem starts once the Slicers are used to filter the data. The "00000 Capacity" series does not keep the Line format and the whole charts becomes Stacked Area.

How can I keep the "00000 Capacity" formatted as Line.

Answer 1

Hi Adrian,

Thank you for your post in the forum.

Per your description, we test on our side. However, we are so sorry that we couldn’t reproduce your situation based on your description, resulting in that we only can do below. Here are my reproducing steps for your reference. If you have any confusion, please feel free to post back, we will try our best to help you out.

First, we create a Pivot Chart, based on the Pivot Chart, click PivotChart in the Tools group under PivotTable Analyze tab > create a Chart > right-click the mouse in the Chart Area > Change Chart Type > change the Combo like your settings > click Slicer under Insert tab > select the aaa, bbb, ccc. For more details, you can refer to the screenshot below.

The two screenshots below are mainly to show the Chart changes when different Slicers selected. 

After filtering the Slicer, the format of Average of aaa will still stay in Line format. I assume it may be related to the different situation, so I would like to collect your steps so that we can test on our side.

(If the steps are complicated, you can also share a sample file with us. Please remove the personal information and upload it to cloud drive, then share the access link with us. Thank you for your cooperation.)

Best regards,

Cindy

Answer 2

Hi Adrian,

Have you solved the Pivot Chart problem? If not, please feel free to post back with more details, we will continue to help you.

Best regards,

Cindy

Answer 3

Hi Cindy,

I have the same question as Adrian.

The issue occurs when you select filters that are incompatible with each other, meaning that in the source table there are no rows that satisfy both filters at the same time. In this way the pivot table will be empty and the chart will be blank.

When you then select two other filters, the combo chart has already lost its formatting.

In your example above, the following steps would make the issue occur:

select bbb = 2       combo chart is ok

->

select ccc = 4         combo chart is ok

->

select bbb=23        combo chart is blank, because there are no data with ccc=4 and bbb=23

-> 

select ccc=5           combo chart is broken, even though there are data with bbb=23 and ccc=5

please find a solution to this or my cool graph and the work I have done to build it will feel useless

thanks

Lorenzo

Answer 4

Same issue.

I have a combo chart set up with stacked area and 2 data pieces as a stacked line.

As soon as I do anything in the slicers the combo settings are lost and I have a one chart of all stacked area.