What am I doing wrong?
 

I thought this was going to be easy but I guess I'm an idiot.
All I want to do is show when job orders decrease Unemployment increases.
I can see job orders but not Unemployment. I was hoping to use the line graph
to show a trend. Thanks for your help.

Month Unemployment Job Orders
January 6.40% 262
February 6.80% 212
March 6.20% 207
April 5.30% 251
May 5.20% 209
June 5.80% 176
July 6.20% 229
August 0.00% 140
September 0.00% 115
October 0.00% 0
November 0.00% 0
December 0.00% 0

What am I doing wrong?
 

You need to put one on a secondary axis as the ranges 0 to .64 (6.4%) and 0
to 262 are so different
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"tjbo" wrote in message
...
I thought this was going to be easy but I guess I'm an idiot.
All I want to do is show when job orders decrease Unemployment increases.
I can see job orders but not Unemployment. I was hoping to use the line
graph
to show a trend. Thanks for your help.

Month Unemployment Job Orders
January 6.40% 262
February 6.80% 212
March 6.20% 207
April 5.30% 251
May 5.20% 209
June 5.80% 176
July 6.20% 229
August 0.00% 140
September 0.00% 115
October 0.00% 0
November 0.00% 0
December 0.00% 0

What am I doing wrong?
 

On Thu, 9 Oct 2008, in microsoft.public.excel.charting,
tjbo said:
All I want to do is show when job orders decrease Unemployment increases.
I can see job orders but not Unemployment. I was hoping to use the line graph
to show a trend.

Once you've made your graph, plot the Job Orders series on the secondary
y axis, by going to Format Series.. Axis

However, I'd suggest that you don't need a Line Chart with two y scales
to show a correlation, you need an XY (Scatter) Chart. Lay the data out
like this:

Job Orders Unemployment
262 6.40%
212 6.80%
207 6.20%
251 5.30%
209 5.20%
176 5.80%
229 6.20%
140 0.00%
115 0.00%
0 0.00%
0 0.00%
0 0.00%

The big problem you have then is that, as far as I can see, unemployment
does *not* increase when job orders decrease.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

What am I doing wrong?
 

Thank you all for all the help. Works great.

"Del Cotter" wrote:

On Thu, 9 Oct 2008, in microsoft.public.excel.charting,
tjbo said:
All I want to do is show when job orders decrease Unemployment increases.
I can see job orders but not Unemployment. I was hoping to use the line graph
to show a trend.

Once you've made your graph, plot the Job Orders series on the secondary
y axis, by going to Format Series.. Axis

However, I'd suggest that you don't need a Line Chart with two y scales
to show a correlation, you need an XY (Scatter) Chart. Lay the data out
like this:

Job Orders Unemployment
262 6.40%
212 6.80%
207 6.20%
251 5.30%
209 5.20%
176 5.80%
229 6.20%
140 0.00%
115 0.00%
0 0.00%
0 0.00%
0 0.00%

The big problem you have then is that, as far as I can see, unemployment
does *not* increase when job orders decrease.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.