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

Doughnut Chart linked with the slicer in the pivot table 0
Pivot Charts - Top Ten And Everything Else 0
Pivot Table Set Up 2
Scatter charts for name with two values 0
Pivot chart - format issue 0
Summary sheet in effecient way 0
Pivot Table Charts - Help Required 1
SUM & OFFSET & PIVOT TABLE?? 0

Top