Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XY Scatter Pivot Chart in Excel 2000
Hello,
I am running Excel 2000. I'm just learning to use Pivot Tables and Pivot Charts so bear with me. I get an error when I try to set my Pivot Chart to XY Scatter. It says: "You cannot use an XY (Scatter), Bubble, or Stock chart type with a chart that has been created from Pivot Table data. Please select a different chart." Is XY (Scatter) available for Pivot Charts in a newer version of Excel? I saw XY (Scatter) chart types are permitted in Access 2003. Access 2003 even provides a list of available charts. http://office.microsoft.com/en-us/ac...CH062526661033 Thanks for the help. Marcus |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
XY Scatter Pivot Chart in Excel 2000
You can't create an XY chart from a pivot table in Excel 2007 either.
You could create a normal chart, based on the pivot table, and make it an XY chart. On Jon Peltier's site, there are instructions for creating a normal chart from pivot data: http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm ew_jammer wrote: Hello, I am running Excel 2000. I'm just learning to use Pivot Tables and Pivot Charts so bear with me. I get an error when I try to set my Pivot Chart to XY Scatter. It says: "You cannot use an XY (Scatter), Bubble, or Stock chart type with a chart that has been created from Pivot Table data. Please select a different chart." Is XY (Scatter) available for Pivot Charts in a newer version of Excel? I saw XY (Scatter) chart types are permitted in Access 2003. Access 2003 even provides a list of available charts. http://office.microsoft.com/en-us/ac...CH062526661033 Thanks for the help. Marcus -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
XY Scatter Pivot Chart in Excel 2000
And there is more information in this article:
http://pubs.logicalexpressions.com/P...cle.asp?ID=553 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Debra Dalgleish" wrote in message ... You can't create an XY chart from a pivot table in Excel 2007 either. You could create a normal chart, based on the pivot table, and make it an XY chart. On Jon Peltier's site, there are instructions for creating a normal chart from pivot data: http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm ew_jammer wrote: Hello, I am running Excel 2000. I'm just learning to use Pivot Tables and Pivot Charts so bear with me. I get an error when I try to set my Pivot Chart to XY Scatter. It says: "You cannot use an XY (Scatter), Bubble, or Stock chart type with a chart that has been created from Pivot Table data. Please select a different chart." Is XY (Scatter) available for Pivot Charts in a newer version of Excel? I saw XY (Scatter) chart types are permitted in Access 2003. Access 2003 even provides a list of available charts. http://office.microsoft.com/en-us/ac...CH062526661033 Thanks for the help. Marcus -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date in scatter chart excel 2003 | Charts and Charting in Excel | |||
Excel - how do I show column grand totals on the pivot chart | Charts and Charting in Excel | |||
Excel 5 and Excel 2000 question. | Excel Discussion (Misc queries) | |||
How do I get a secodary axes to stay on a excel 2003 pivot chart | Charts and Charting in Excel | |||
Excel XP Pivot Table in Excel 2000 | Excel Discussion (Misc queries) |