View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Pivot Chart Question

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?