Pivot Chart based on a pivot table changes
 

I have a pivot table and now I am trying to get the pivot chart ploted
against it, I have the following issues and I am using excel 2003

when I insert the chart and arrange the chart (x axis and y axis data) the
way I want it to be displayed, the pivot table is change completely, I dont
want the pivot table to be changed but want to see my chart the way I intend
to see. Please help

Thanks

You can't change the pivot chart without changing the pivot table on
which it's based.

Perhaps you could create a second pivot table, and base the chart on
that. Or, there are instructions on Jon Peltier's site for creating a
normal chart from pivot data:

http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm


dineshnewcomer wrote:
I have a pivot table and now I am trying to get the pivot chart ploted
against it, I have the following issues and I am using excel 2003

when I insert the chart and arrange the chart (x axis and y axis data) the
way I want it to be displayed, the pivot table is change completely, I dont
want the pivot table to be changed but want to see my chart the way I intend
to see. Please help

Thanks


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html