Pivot Chart Question

M

Mike

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?
 
S

Shane Devenshire

Hi,

In the pivot table select the all the clients from 6 to 200 (in the row
area) then choose the command PivotTable, Group and Show Detail, Group. This
should give you 6 items in a new row field. Remove the original field from
the pivot table, rename the Group 1, Other. Generate your chart from this.

If this helps, click the Yes button

Cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Set Up 2
Pivot Table Charts - Help Required 1
Pivot Table Count 3
Consolidate Pivot table from multiple files 4
Add Sales Goals to Sales Report in Pivot Table 1
Showing Pivot Table total on Associated Pivot Chart 2
Pivot Table 1
Pivot Table Data Column Sort Excel 2007 1

Top