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
|