scatter plots using pivot table data

[Dan]

In older versions of Excel, you could directly create xy
scatter plots using pivot table data. In Excel 2000, the
chart wizard says you can't use an xy scatter plot with
pivot table data. Why????? Is there any way around this
limitation?

 

[Jon Peltier]

Dan -

Don't tell the pivot table you're making a regular chart.

Select a cell away from the PT and start the chart wizard. Select the XY
Scatter type you want in step 1. In step 2, use the Series tab to select
the ranges for the names, X values, and Y values of each series in your
chart. Make sure you don't select one of the PT buttons.

I do this all the time, because I use pivot tables a lot, and I hate
pivot charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______