pivot chart behavor

[lezawang]

Hi
I created pivot table like this

[TABLE="width: 200"]
<tbody>[TR]
[TD]dept[/TD]
[TD]salary[/TD]
[/TR]
[TR]
[TD]sales[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]admin[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]hr[/TD]
[TD]30[/TD]
[/TR]
</tbody>[/TABLE]

Then I inserted pivot chart - Pie chart. everything is fine so far. Now when I insert City as a column in the pivot table (see below) then the Pie chat wont work anymore. How can I fix the pivot chart to show the first 2 columns (dept and salary in this case) and not to change no matter how many other columns I entered? Thank you so much

[TABLE="width: 200"]
<tbody>[TR]
[TD]dept[/TD]
[TD]london[/TD]
[TD]Paris [/TD]
[TD]NY[/TD]
[TD]LA[/TD]
[TD]salary[/TD]
[/TR]
[TR]
[TD]sales[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]1[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]admin[/TD]
[TD]10[/TD]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]hr[/TD]
[TD]5[/TD]
[TD]20[/TD]
[TD]5[/TD]
[TD][/TD]
[TD]30[/TD]
[/TR]
</tbody>[/TABLE]

 

[RoryA]

You can't. A pivot chart will always use all the data from its source pivot table (excluding grand totals).