Break Pivot Into Multiple Tables
I am trying to use a pivot graph to show the status of 50 or so different projects in a 10 step process so each project is a column with the steps of the process being the Y-axis. The problem is when I have 50 columns on a graph it becomes impossible to read, is there a way to force a pivot graph to create multiple graphs that only displays a certain number of items in each graph. The spreadsheet is also connected to a SharePoint page to get the project information so it is subject to change and manually hiding on a pivot table to filter data wouldn't work well.
|