You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
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 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.
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 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.
You can read more of Rob’s post here:
http://powerpivotpro.com/2010/02/05/powerpivot-data-in-scatter-charts-etc/
As Colin states in one of the comments to the post, 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.
Comments: (5) Collapse
Stock charts are easy enough. Put your columns in Date-OHLC order, and make a line chart. Add high-low lines and up-down bars, then remove marker and line formatting on the four series.
well i have read their post,it was easy.But for a beginner i think there must be more detailed example and video tutorials.
I will prefer open office if the new version is s-o strange. I like more 2003 than 2007. I don't understood why 2003 function is not prezent in 2007
Cazaresulina,
there is a software which adds a ribbon with the 2003 functions i just dont remember the site from where i downloaded it. its just a 700kb file which u run and get the 2003 menu in an extra ribbon of the 2007 office
Comments: (loading) Collapse