thanks for the reply. The worksheet is set up with the furthest left column
as Dec 2006 -reading left to right through Jan 2005 which is the furthest
right colum.
i.e., 12/06 11/06 10/06 ......12/05 11/05 ....1/05

"Bernard Liengme" wrote:

Tell us how the data is layout on the worksheet and where the "new" Jan is
entered.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"suezylogan" wrote in message
...
I am creating a chart to compare values year over year. Ordering in the
worksheet reads Dec-Jan Left to Right. When I select the series in chart
wizard, excel is assigning Jan as value 12, Feb as value 11, etc with Dec
as
1. Then I attempt to add Jan and Feb of 2006 and it assigns Feb as value 1
and Jan as value 2---therefore comparing it to Dec and Jan of 2005. Any
ideas
on how to change the way excel is reading these values?

Thanks