Pivot Tables and Charts

A

amanda

Is there a way to make a table and then when i change the chart have it to
where it does not turn around and change the table
 
D

Debra Dalgleish

Create another pivot table, based on the first one. Then, create the
pivot chart from the second pivot table. You can hide the sheet that
contains the second pivot table.

When you change the pivot chart, only the hidden pivot table will be
affected.
 

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

Dealing with a Pivot Table (when I don't want to) 0
Embed the same Excel multiple times 0
Ways to create a budget chart for money managment 1
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Multiple charts from Pivot Table 0
Creating a Chart on form from selected data in query. 0
Move Chart with Text 0
Bar Chart with Data Elements 1

Top