I take it that using a scatter approach involves highlighting a dates column (x) and a data column (y). Do these columns have to be adjoining? Must the dates column be to the left of the data column? Can you designale which column in dates and which column is data?
Bookmarks