Charting

[Enrique]

I'm creating what I call a running total spreadsheet where I list the Item,
Category, & Amount as column headers. Examples could be:
1) Printer, Hardware, $150
2) Visio, Software, $150
3) Computer, Hardware, $2000

How can I create a chart that sums all the Categories (Hardware = 2150)
together. Everything I try, list each line item separately.

Thanks,
Enrique

 

[Frank Kabel]

Hi Enrique:
Two ideas:
1. Create a pivot table and build a charts based on this table (look at
http://www.cpearson.com/excel/pivots.htm for an introduction to pivot
tables)
2. Create a seperate sheet in which you sum up all your categories with
SUMIF formulas

HTH
Frank