Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding up pie slaces of the same thing?
Here is what I am trying to do:
Kroger $29.90 Ebay $20.00 Kroger $10.00 Best Buy $40.00 Kroger $51.00 Gas $35.00 Gas $50.00 Create a pie chart of this data where Kroger, Best Buy, etc only appear once in the pie chart. Currently the default is to create a pie slice for each entry, where I would like it to add up the Kroger values and present it as one pie slice. I want it to do this for any similar entries. Is there an easy way to do this? Thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Adding up pie slaces of the same thing?
I would do a pivot table summing the quantity for each then graph the
results. Rita Khensu wrote: Here is what I am trying to do: Kroger $29.90 Ebay $20.00 Kroger $10.00 Best Buy $40.00 Kroger $51.00 Gas $35.00 Gas $50.00 Create a pie chart of this data where Kroger, Best Buy, etc only appear once in the pie chart. Currently the default is to create a pie slice for each entry, where I would like it to add up the Kroger values and present it as one pie slice. I want it to do this for any similar entries. Is there an easy way to do this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i repeat one thing to a row? | Excel Discussion (Misc queries) | |||
Strange thing happens... | Excel Worksheet Functions | |||
One Last Thing | Excel Discussion (Misc queries) | |||
Is there such a thing... | Excel Discussion (Misc queries) | |||
one more thing | Excel Worksheet Functions |