Help with creating a chart

I am trying to make a chart for the first time, and just can't seem to get it to do what I want. I'm sure its because of the data I have and/or how I have it set up.

Basically I want a chart of some sort (style doesn't really matter at this point) that will show me two things. # of step 3's and # of step 4's by the year and the cost associated with each. I currently have this broken up by department via tabs as well, but if I can have it all on one sheet, might be better. If I can have on one sheet, then I think I will need a seperate chart (maybe pie?) that shows that number by department for the whole year. If I have it on one sheet, I would have another column called "Department".

On my real spreadsheet the information in column G is gotten from a drop down and column I has a formula. (Don't know if that makes a difference or not).

So the chart(s) needs to show:
Total # of Step 3's for each year
Total # of Step 4's for each year
Total cost for the year for step 3's
Total cost for the year for step 4's

If I can put all departments on same sheet, a chart that shows:
# of Step 3's for each department vs all departments for the year
# of Step 4's for each department vs all departments for the year

I think that's it. I hope this makes sense!

If I'm understanding what you want this should give you the first graph....I created a pivot table and grouped your dates by years....then I created a 2 axis line graph....HTH....

after you have created PT, right click on any date in the list and you should see Group...click on that and choose Year and unclick Month (usually the default)....

if you want to do weeks (later on when you are playing)....click days and choose 7....

glad I could help....Pivot tables are the best thing in excel....

thanks for the "*"

oops....try this....in your pivot table field list...drag the step field into the row label box below the date...

sweeeeeeeeeeeet.....kind of a cool little graph....have fun....