Don't you normally get a message when you want to chart from a PivotTable to
ask where you want the chart to appear? Any chart I make appears on a
seperate worksheet. Is there an option to change the default to have the
chart appear on the same worksheet as my pivotTable?