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.


city name sum of salary sum of salary2 (rank largest to lowest)
ottawa 100 2
toronot 200 1
london 50 3
ajax 30 4