I have data of my weekly pay and hours worked. I want to show the
correlation between the two. When I do a linear regression it doesn't
work, and I don't understand why the correl function is for the range
of each data set.

For example:

5/1 $100 5 hours
5/15 $200 7 hours
5/30 $50 3 hours
etc.

I have the money and hours graphed on a charted over time, on two
separate axis. now how do I show the correlation between them on this
chart?

I tried to use the CORREL function to do somthing like this :

CORREL (money1:money3,hours1:hours3)

but the amount comes out as a really small decimal, like .04. Even if
I switch it around, and do hours,money I get the same amount. I am
thinking that I should not have the hours charted on the second axis,
but don't understand how I get the correct correlation percentage
charted.

Please help!

Thanks!