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

 

[Cerridwen]

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

You'd be better off posting this to a dedicated Excel group (include your
version) - try microsoft.public.excel.worksheet.functions.

 

[Chris Schatte]

Try searching Templates for Excel
http://office.microsoft.com/search/results.aspx?Scope=TC&Query=excel&CTT=6&Origin=EC010331121033
There are some very good templates that you can modify to suit your needs.

 

[Arnold Gao [MSFT]]

Hi Enrique,

Thanks for posting here!

It appears that this is a development-related request that would be best
addressed in the developer newsgroups. The developer newsgroups are located
at: http://msdn.microsoft.com/newsgroups/default.asp.

Your understanding on this will be greatly appreciated.

Thank you for your time!

Sincerely,

Arnold Gao

Microsoft Partner Online Support


Get Secure! - www.microsoft.com/security

====================================================
When responding to posts, please "Reply to Group" via
your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and
confers no rights.

 

[Enrique]

Thanks,
With some small modifications, I found a template that was perfect.

 

[Arnold Gao [MSFT]]

Hi Enrique,

It's nice to hear that you've found what you need.

Have a nice day,Enrique!

Sincerely,

Arnold Gao

Microsoft Partner Online Support


Get Secure! - www.microsoft.com/security

====================================================
When responding to posts, please "Reply to Group" via
your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and
confers no rights.