Excel 97 was no smarter than Excel 2003. Insert a few blank columns to make
room for Don's suggestion. Five minutes spent with the data will save five
hours of finagling.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Don Burgess" wrote in message
...
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