• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

TreeMap Use PowerPivot Table

S

Suhel_here

New Member
Hi All,

I need your help badly, i am using a work book with data in power pivot alone with Slicer, however i want to use this Power pivot table to use in my Treemap, bubble, sunbust & histogram chart, please help me please. Thank in advance you :)

Regards
Sohail


Moved by Moderator
 
Last edited by a moderator:
PivotTables have limitations on chart options. You can't use the chart types mentioned with data inside a PivotTable. However, you can re-expand data and/or by transforming data model and loading it as simple table, you can utilize these charts.

Note:
Histogram: You'd need calculated column for "Bin". To group values with.
 
Sohail

Firstly, Welcome to the Chandoo.org Forums

Power Pivot and the other Power Tools are all still work in progress
Expect to see regular updates in functionality and addition of new features in future updates.

Keep an eye on posts at: https://blogs.office.com/excel/
 
You must log in or register to reply here.
Back
Top