1
I have a pivot table and pivot chart and they are both working fine. However, I have a couple of series in the pivot table that I don't want to show in the pivot chart. I also do not want to expand and contract the chart as I do the same in the pivot table.
Questions
- Can I have a pivot chart with a subset of the series in a pivot table?
- Can I prevent the pivot chart from changing when I expand and contract the rows in a pivot table?