PivotCharts On The Same Sheet

  • Thread starter Thread starter Cindy
  • Start date Start date
C

Cindy

Hello. This should be pretty simple: I'm trying to put twenty pivot
tables on one sheet and their equivalent pivot charts on another. Any
ideas?

Thank you very much in advance.

Cindy
 
Right click each pivot chart, choose Location, then As Object In and select
the same destination sheet for all charts.

- Jon
 
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

Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
Refresh PivotChart subform 3
Summary sheet 2
chart from pivot data, and sheet data? 5
Pivot Chart - Disassocoation from PivotTable 1
Using VBA to create charts 1
Refreshing external data on individual sheets in a specific sequen 1
how to make grand total to show up on pivotchart? 0

Back
Top