PivotTable Charts

  • Thread starter Thread starter Joey
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error : No more new fonts may be applied in this workbook 3
Cannot update "Chart data range:" Field 2
Pivot Chart Data Data range cannot be changed 2
Automatically shift chart data range: redux 6
how to make grand total to show up on pivotchart? 0
How to include totals in charts based on pivottables? 1
GetPivotData 1
Please help! Cannot open pivotTable source file.... 2

Back
Top