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 :)

Need Your Help

Alfresco scoped webscript configuration, can it be loaded into an E4X object?

javascript alfresco e4x

I'm looking to use a scoped configuration file in an Alfresco javascript webscript. I started with this wiki page, and it got me mostly there.