PowerPivot and DAX papers,posts,FAQs,webcasts,samples

At right is a list of all chart types in Excel.  But not all of them are supported as PivotCharts.  Try to use XY (Scatter), Bubble, or Stock as a PivotChart, and you’ll get the alert below:

You cannot use an XY (Scatter), Bubble, or Stock chart type with a chart that has been created from PivotTable data. Please select a different chart type.

So, do you give up?

Nope.  Remember the post where I converted a PivotTable to Cube Formulas using that button on the ribbon?  This is a wonderful opportunity to use that feature in an unexpected way.

Once it’s converted to formulas, you can create any chart type you want against it, no restrictions.  It’s just regular old cells now.

Read more...