What am I doing wrong?

  • Thread starter Thread starter tjbo
  • Start date Start date
T

tjbo

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
 
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
 
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.
Click to expand...

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.
 
Thank you all for all the help. Works great.

Del Cotter said:
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.
Click to expand...
 
Back
Top