View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Data Monkey Data Monkey is offline
external usenet poster
 
Posts: 1
Default Pie Chart with automatic "All Other" group

Hi there,

I have a long list of "accounts" that have a dollar value next to them. I
would like to get the top accounts by dollar to show up individually in a pie
chart but have a group encompassing the remainder of smaller accounts, so the
total pie value is summation of the entire set of accounts' values. Same
should be able to be done on a stacked bar.

Is there a dynamic way to do this so I don't have to manually create the
"below the line" group?

Thanks,
-data monkey