My colleague Debra Dalgleish has posted this tutorial on my web site:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivotcharts.htm
IMHO, pivot charts are a great idea whose time hasn't yet come. There
is a limited choice of chart types, the chart can be formatted only in
limited ways (you can't change the PLOT AREA!), the whole pivot table
must be included, and whatever formatting you may have applied is
obliterated when the pivot table is updated.
I generally make regular charts from pivot table data. In Excel 97,
which I still use at work, it's no big deal, since '97 has no pivot
charts. In later versions, you have to select a blank cell away from
the pivot table before you start the chart wizard, then select the
ranges on the Series tab of the Source Data form (step 2 of the wizard),
one series at a time.
- Jon
