pivot chart behavor

[lezawang]

Hi
I created pivot table like this

dept	salary
sales	10
admin	20
hr	30

<tbody>
</tbody>

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

dept	london	Paris	NY	LA	salary
sales	5	4		1	10
admin	10	10			20
hr	5	20	5		30

<tbody>
</tbody>

 

[RoryA]

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