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