pivot table chart issue

[lezawang]

Hi I have pivot table like the one below
City Name as row labels and Salary as value, then I put Salary as value again but then changed "show value as:" From Largest to Lowest. Now when I try to create a chart from that table, I went to Option-->Pivot Chart and I selected Bar chat. The problem the chart is show 2 series, the Sum of Salary and the Sum of Salary2. When I tried to delete Sum of Salary from the chart, It would delete that column from the pivot chart too? How can I delete the sum of Salary2 chart without deleting the column in the pivot table? Thank you so much.


[TABLE="width: 500"]
<tbody>[TR]
[TD]city name[/TD]
[TD]sum of salary[/TD]
[TD]sum of salary2 (rank largest to lowest)[/TD]
[/TR]
[TR]
[TD]ottawa[/TD]
[TD]100[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]toronot[/TD]
[TD]200[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]london[/TD]
[TD]50[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]ajax[/TD]
[TD]30[/TD]
[TD]4[/TD]
[/TR]
</tbody>[/TABLE]