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
Are your values really values or text. Text will be treated as zeros.
Post workbook of data if still stuck
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.
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:
Fabulous!!! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks