Multiple Pivot tables to Pivot Chart

[Greg Cotten]

How can you merge two Pivot tables to one Pivot Chart? Is there a
Chart option that will allow this?

Thanks,

Greg

 

[Jon Peltier]

Greg -

Make a regular chart from dummy data. Then from the Source Data dialog
(Chart menu), remove the dummy series and add the series from data
ranges in the individual pivot tables. I often do this when the source
data is a single pivot table, because pivot charts aren't as flexible as
regular charts, and if you reset the pivot table, all the formatting in
the pivot chart is also reset.

- Jon