Archive of Mr Excel Message Board


Back to Pivot Tables in Excel archive index
Back to archive home

charts from pivot tables

Posted by maura on December 06, 1999 12:54 PM
I want to make several charts using data from a
single pivot table. The problem is when I change
the pivot, the charts change as well. Is there
any way to make the chart not update with the
pivot table once I'm satisfied with the chart?

Re: charts from pivot tables

Posted by Denise on December 15, 1999 10:00 AM
Hi Maura,

You can make charts from Excel 2000 pivot tables easily.
You go through the usual steps of choosing chart wizard,
then your chart type, etc. Then what happens is that
instead of using the default "Data Range" tab, click
on the tab behind it, "Series". Choose your X and Y
variables from here. This will allow you to make your
chart from a pivot table.

Good luck!
Denise


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.