3 Columns: Item, Cost, Category

I want to make a pie chart containing category & cost. Why isn't it as easy as it should be & how do i do it.

[Edited on August 28, 2005 at 3:14 AM. Reason : *]

8/28/2005 3:10:32 AM

http://phoenix.phys.clemson.edu/tutorials/excel/graph.html

8/28/2005 3:38:43 AM

8/28/2005 8:04:04 AM

insert->chart
select pie
series tab
name box, click the button to the right of the box
click and drag to select your categories
click the X to close the box
values box, click the botton to the right of the box
click and drag to select your values
click the X to close the box
category labels box, click the button to the right of the box
click and drag to select your categories
click the X to close the box


i don't think excel can simply add all the categories together that are the same. i think you have to do that before hand and then make a pie chart off that data if you are trying to do what i think you are trying to do.

8/28/2005 9:25:29 AM

well i figured i could do it that way, but as the list grows longer its not something i want to continually update

8/28/2005 10:43:53 AM

well I suppose you could write a macro do update it for you, but thats really the best way

8/28/2005 10:47:47 AM