Pivot Chart based on a pivot table changes

[dineshnewcomer]

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]

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