Graphing Rows?

[raychel_87]

Hey guys, me again.
I have a (hopefully) quick question. In my spreadsheet I have my x values in one row (with 4 cells with no data entry between each real x value) and the same thing for my y values in the row below it. I did it before where I could select the entire row of x and y values and it would graph fine, but now when I do it nothing shows up on my graph... not sure if I am forgetting to do something or if the first time was just a fluke.
Any ideas?
Thanks!
Raychel

[Andy Pope]

Are your values really values or text. Text will be treated as zeros.

Post workbook of data if still stuck

[raychel_87]

Okay - the x-values are actual numbers, same with the y's.
I attached a sample portion.
In the worksheet, row 4 is the "x-value" with corresponding y-values in row 5.
Another series has x-values in row 10 and y-values in row 11. I tried graphing it (in Chart1) but nothing comes up.

[Andy Pope]

There are no lines because of the gaps in your data.
If you change the chart to xy-scatter line with markers you will see the markers appear.

If you want a line you will need to select the Plot empty cells as - interpolated.
menu, Tools > Options > Chart > Plot cells as:

[raychel_87]

Fabulous!!! Thanks!