Another option would be to use formulas from the Pivot Table, then create a chart from that, not on a chart sheet, but a normal worksheet. Or use VBA and create the Pivot and the chart entirely in VBA.
[Edited in light of next post]
Last edited by shades; 11-01-07 at 11:12.
old, slow, and confused
but at least I'm inconsistent!