View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default charting how many widgets over time

Select a blank cell away from any pivot table. Start the chart wizard, and
select a chart type in step 1. In step 2, click on the Series tab, and add
each series separately. This will prevent the chart from being converted
into a pivot chart.

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

wrote in message
oups.com...
Greatl, thanks, Jon. That all worked great. So now I have three
charts based on the three pivot tables for each project. But how do I
create a chart that will compare apples across all projects, oranges
across all three projects, etc.?

Excel does not seem to allow me to choose source data within a pivot
table to build one chart for this...

Thanks.