Rob over at http://powerpivotpro.com has a interesting post on scatter charts and PowerPivot: 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 an alert saying you cannot create it with pivot data. 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
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2010/02/24/scatter-charts-in-powerpivot.aspx
Posted
Feb 24 2010, 04:30 PM
by
Microsoft Excel 2010