Windows 7 Discount Scatter charts with PowerPivot

Rob over at 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),Microsoft Office 2007 Pro Plus, Bubble, or Stock as a PivotChart,Office 2010 Sale, and you’ll get an alert saying you cannot create it with pivot data.So,Office 2010 Product Key, 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,Windows 7 Discount, you can create any chart type you want against it, no restrictions. It’s just regular old cells now.You can read more of Rob’s post here:As Colin states in one of the comments to the post,Office 2007 Activation, there’s multiple ways to get a scatter chart on PivotTable data. From creating formulas based on the PivotTable to inserting a blank chart and using the add series dialog to select the cells. Attached to this post is a simple example. <div