lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
<tbody>
</tbody>
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 |
<tbody>
</tbody>