You can make a regular chart from a pivot table: select a blank cell that
isn't touching the pivot table, start the chart wizard, and when you get to
the Source Data dialog (step 2), click on the Series tab. One by one, add
each series, then select the appropriate ranges for X and Y.

This regular chart will not update automatically when the pivot table
changes. You can use dynamic range names to let the length of each series
change with the changing data
(http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html), but dynamic
names cannot be used to change the number of series in a chart, without at
least using VBA to add or remove series.

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