Calculating Chart Values over large Ranges with catagories

**shealy06** · 11-04-2008, 01:19 PM

I am working on a custom log file for my company. It has 3 sheets and on each sheet is a service type column with drop downs and next to it an amount coumn. Every day that a service issue is requested someone goes in and chooses the service type from the drop down and enters the amount in USD.

I want to add charts to the top of each sheet and on the axis i want to have service type and then the total amount spent on that catagory

I cant figure out how i would do this and would GREATLY appreicate any help!!

thanks,

Sean

**VBA Noob** · 11-04-2008, 01:22 PM

Hi Sean,

Welcome to the forum

Please take a few minutes to read the forum rules below and then amend you're title

Many thanks

VBA Noob

**jwhitwell** · 11-04-2008, 01:25 PM

Insert enough rows at the top to give you the space you want. In that space, you can summarize the data in two columns:

Service 1 $XXX
Service 2 $YYY
Service 3 $ZZZ

Column A there is all of the possible choices in the drop-down; column B can be a 'sumif' formula that adds up all of the dollar amounts when it finds the right service type...

Using that summarized data, create/insert your chart in the space (can lie on top of your summary data)!