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.