Chart consolidated month, from list of day dates

[gideon]

I have data in 2 columns...........hours,date.
I have many rows of data for each day of each month. how can I produce a chart that consolidates to month level, i.e. one column per month. Here's an example of the data.....I want a graph that shows March and April hours consolidated.
Hours Date
2 01/03/2000
3 01/03/2000
3 03/03/2000
2 01/04/2000
3 01/04/2000
3 03/04/2000

 

[Juan Pablo González]

Have you tried a pivot chart ? or if using Excel 97, a Chart based on a Pivot Table ? you can use Grouping to have your dates appear as months.

 

[gideon]

oops....I meant to say, I have a third column, Department that I want to chart with also.

 

[Juan Pablo González]

Still, Pivot Tables and Pivot Charts.