Hello, I have following problem:
Pivot chart combined - one category has "line" type and other have column stacked. it is displayed exactly in way I need.
BUT: When I filter-out one value from the chart, the format of the chart does not keep.
It is obvious from attached file:View attachment Pivot_chart.xlsx
If I uncheck Peter from the pivot chart (or pivot table) the whole chart is column stacked now.
Could you please help? How to do to the chart keeps its format?
Thanks.
Pivot chart combined - one category has "line" type and other have column stacked. it is displayed exactly in way I need.
BUT: When I filter-out one value from the chart, the format of the chart does not keep.
It is obvious from attached file:View attachment Pivot_chart.xlsx
If I uncheck Peter from the pivot chart (or pivot table) the whole chart is column stacked now.
Could you please help? How to do to the chart keeps its format?
Thanks.