PivotTable Charts

J

Joey

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?
 
R

Roger Govier

Hi Joey

That is the default action in Xl2003 and lower.
Once the chart is created, you can Right click on the Chart>Location>As
Object in>choose Sheet
 
Top