ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 333
- Office Version
- 365
- Platform
- Windows
How can i make 2 charts from a single pivot table (showing name and amount). 1 of the chart will show the top 20 filtered values and the other chart will filter values that are not included in the top 20.
I did it with 2 pivot tables. 1 pivot table is filtered values of "top 20" while the others is filtered "bottom 15". the issue here is if a new name (and amount) will appear in the pivot table i will need to manually update the bottom 15 to bottom 16 and so on..
I am wondering if there is a way to do this without manual updating the pivot table?.. thank you
I did it with 2 pivot tables. 1 pivot table is filtered values of "top 20" while the others is filtered "bottom 15". the issue here is if a new name (and amount) will appear in the pivot table i will need to manually update the bottom 15 to bottom 16 and so on..
I am wondering if there is a way to do this without manual updating the pivot table?.. thank you