software

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

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

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

quot;Bernard Liengmequot; wrote:

gt; Tell us how the data is layout on the worksheet and where the quot;newquot; Jan is
gt; entered.
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;suezyloganquot; gt; wrote in message
gt; ...
gt; gt;I am creating a chart to compare values year over year. Ordering in the
gt; gt; worksheet reads Dec-Jan Left to Right. When I select the series in chart
gt; gt; wizard, excel is assigning Jan as value 12, Feb as value 11, etc with Dec
gt; gt; as
gt; gt; 1. Then I attempt to add Jan and Feb of 2006 and it assigns Feb as value 1
gt; gt; and Jan as value 2---therefore comparing it to Dec and Jan of 2005. Any
gt; gt; ideas
gt; gt; on how to change the way excel is reading these values?
gt; gt;
gt; gt; Thanks
gt;
gt;
gt;

Still need some additional information. Three points, questions:

1. Data Organization: I suggest that you change your data arrangement. The
standard convention is to have x variable in column A and Y variables in
columns B, C, etc.

2. Date Format: Are you using actual dates to designate your months or are
you using text.

3. Chart Type: Are you using Line or XY (Scatter) chart type?quot;suezyloganquot; gt; wrote in message
...
gt; thanks for the reply. The worksheet is set up with the furthest left
gt; column
gt; as Dec 2006 -reading left to right through Jan 2005 which is the furthest
gt; right colum.
gt; i.e., 12/06 11/06 10/06 ......12/05 11/05 ....1/05
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; Tell us how the data is layout on the worksheet and where the quot;newquot; Jan
gt;gt; is
gt;gt; entered.
gt;gt; best wishes
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;suezyloganquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I am creating a chart to compare values year over year. Ordering in the
gt;gt; gt; worksheet reads Dec-Jan Left to Right. When I select the series in
gt;gt; gt; chart
gt;gt; gt; wizard, excel is assigning Jan as value 12, Feb as value 11, etc with
gt;gt; gt; Dec
gt;gt; gt; as
gt;gt; gt; 1. Then I attempt to add Jan and Feb of 2006 and it assigns Feb as
gt;gt; gt; value 1
gt;gt; gt; and Jan as value 2---therefore comparing it to Dec and Jan of 2005. Any
gt;gt; gt; ideas
gt;gt; gt; on how to change the way excel is reading these values?
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt;
gt;gt;
gt;gt;