Hello,
I created a pivot table that is being linked to a slicer. My slicer allows me to switch the data being presented by different views. However, when I switch around, my pivot charts keep changing the chart type (i.e. my intention is to have a combo chart, but it keeps switching to a bar chart).
Any idea on how to lock a specific chart type into a pivot chart?
I created a pivot table that is being linked to a slicer. My slicer allows me to switch the data being presented by different views. However, when I switch around, my pivot charts keep changing the chart type (i.e. my intention is to have a combo chart, but it keeps switching to a bar chart).
Any idea on how to lock a specific chart type into a pivot chart?
