Manster
Member
Hi Experts,
I have a problem regarding the pivot chart when filtering using a slicer. My problem is:
The chart format will change when I filter the data, for example, "Year". The "Target" line will change to the clustered column.
Therefore, I hope anyone can help me to maintain the line of "Target" if I filtered the chart, and at the same time, other data like A, B, C, D, E will maintain the clustered columns.
Please find an attachment (Combo Pivot Chart) for your kind attention.
Thank you.
I have a problem regarding the pivot chart when filtering using a slicer. My problem is:
The chart format will change when I filter the data, for example, "Year". The "Target" line will change to the clustered column.
Therefore, I hope anyone can help me to maintain the line of "Target" if I filtered the chart, and at the same time, other data like A, B, C, D, E will maintain the clustered columns.
Please find an attachment (Combo Pivot Chart) for your kind attention.
Thank you.