Archive of Mr Excel Message Board
Back to Pivot Tables in Excel archive index
Back to archive home
charts from pivot tablesPosted 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 tablesPosted by Denise on December 15, 1999 10:00 AM
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.
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.