D
Debra Dalgleish
As answered in .excel.misc:
There are some instructions on Jon Peltier's web site:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivotcharts.htm
'=======================================================
To create a normal (non-pivot) chart from a Pivot Table:
1. Select an empty cell away from the Pivot Table.
2. Click the Chart Wizard button on the toolbar.
3. Click Finish, to create an empty chart.
4. Select cells in the Pivot Table, and drag or copy them to the
blank chart.
Note: If you select a cell which contains a Pivot Table button, the
chart will become a Pivot Chart. To avoid this, you can build the chart
from the data and either the series or category axis labels. Then choose
Chart>Source Data. On the Series tab, select a series. Click on a
worksheet cell to add the series name or Category axis label.
'=======================================================
There are some instructions on Jon Peltier's web site:
http://www.geocities.com/jonpeltier/Excel/Pivots/pivotcharts.htm
'=======================================================
To create a normal (non-pivot) chart from a Pivot Table:
1. Select an empty cell away from the Pivot Table.
2. Click the Chart Wizard button on the toolbar.
3. Click Finish, to create an empty chart.
4. Select cells in the Pivot Table, and drag or copy them to the
blank chart.
Note: If you select a cell which contains a Pivot Table button, the
chart will become a Pivot Chart. To avoid this, you can build the chart
from the data and either the series or category axis labels. Then choose
Chart>Source Data. On the Series tab, select a series. Click on a
worksheet cell to add the series name or Category axis label.
'=======================================================