Manually Enter X-Y Range Data to Series Values

I am trying to plot a simple line (y=-20) on a chart that I have. I would like to be able to do this without having the actual range data on chart. Ie XValues = 0:20000
YValues = -20:-20
When I select these values on my chart, it works perfect. When I try to enter a manual range in, it gives me an error. What do I need to do to correct this?

Example: Right now my XValues = Sheet1!$A$1:$A$2

Where A1 = 0 and A2 = 20000

What is the difference between this and XValues = 0:20000?

Included is a workbook with an example of what its doing. It's really basic and probably worthless, but if I am not making myself clear enough, it might help.

I eventually want this to be entered in with a macro, but I figured the syntax would be the same, so I'll ask here.

Thanks in advance,

Eric

With code you would use

Please Login or Register  to view this content.

manually you can select the series and then go to the formula bar. Highlight a range and press F9. This will convert range to array of values.

So your series formula starts out as

=SERIES(,Sheet1!$A$1:$A$2,Sheet1!$B$1:$B$2,1)

and end up as

=SERIES(,{0,20000},{-20,-20},1)