Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
"num#" errors .. how to average a group with a "num#" error | Excel Discussion (Misc queries) | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) | |||
=IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 | Excel Worksheet Functions | |||
"Data Group and Outline Group" feature Limited to 8 levels | Excel Discussion (Misc queries) | |||
How do i enable "Group" & "Ungroup" in a protected sheet | Excel Discussion (Misc queries) |