Splitting a pivotchart from power pivot into multiple charts
I have a pivot chart that tracks resource allocations based on a few filters. I would like to split the chart into multiple charts. In the picture, I want one chart for each line. I can do this manually (one chart for each resource) but that's not ideal because I only want to see certain charts based on the filters, and the data will change frequently.
Thanks in advance for help.
reference - http://imgur.com/vZJEHGM
Blake, unfortunately, this is not possible. Chart based on (power)pivot table is always linked and if you update the pivot table, you will see the change instantly happen to the chart as well.
What I would suggest is to create four (or more) different pivots and then four (or more) linked pivot-based charts.
If there is any filter that needs to be used in all of the pivot tables, you can then use slicers which can be linked to more than 1 pivot table.
Hope this helps :)