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

Answers


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

Displaying a loader in a table cell

jquery html css

I have some problems with displaying an AJAX loader inside a table cell.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.