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.