I try to create both a normal and pivot chart based on select columns in a pivot table, but the chart shows all columns. How do I just create the chart based on select columns only?
PS- I know I can just deselect certain columns from the Values area but it gets tedious taking them out and putting them back in
Bookmarks