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.
