Thank you. I was wondering if there's a way to create the graph without
adding more columns to the right of the data, since I already have some other
data there.

I seem to remember Excel 97 automatically figured out which data points
belonged in which month, and set up the graph accordingly.

Don Burgess

"Don Guillett" wrote:

suggest you make another table with
month total for month
Jan =SUMPRODUCT((MONTH(C2:C7)=1)*D2:D7)
etc
--
Don Guillett
SalesAid Software