ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Pivot Charts - Top Ten And Everything Else (https://www.excelbanter.com/charts-charting-excel/210953-pivot-charts-top-ten-everything-else.html)

Mike

Pivot Charts - Top Ten And Everything Else
 
I have a Pivot table that shows monthly sales by client. Approximately 200
clients are shown. As with most businesses, about 80% of the sales comes from
20% of the clients.

I want to create a pivot chart that will show the individual results for the
the top ten clients along with all other clients grouped together as a single
result. Can this be done?


All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com