How do re-order values assigned by Excel for chart data?
 

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

How do re-order values assigned by Excel for chart data?
 

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

How do re-order values assigned by Excel for chart data?
 

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

How do re-order values assigned by Excel for chart data?
 

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?








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