Can I choose what columns of data from a pivot table display on a chart without removing the unnecessary columns from view on the pivot table? I have a pivot table with 32 columns of data and we like to look at the table with all data in view, but I want to create 4 different charts each displaying the data from a few different columns. When I make the chart it pulls all 32 columns, and when I try to remove a column it removes it off the pivot table too.
I want my spreadsheet laid out like this:
pivot table with all rows and columns visible
chart 1
chart 2
chart 3
chart 4
so you can scroll through the table then continue scrolling to see each chart.
Also want to mention that I add new rows of data to the original "raw data" tab occasionally. My pivot table can be refreshed to include the new data of course, but just wanted to mention it in case the solution to my chart issue includes manipulating the original source data.
Thanks for the help!
Bookmarks