can someone please help me create a scatter plot with one series as dates. i know this sounds simple, but the graph is converting the date series to numbers, and then plotting them as 1900 dates. help would b much appreciated.
they are real dates. for example, if you have two columns, a and b. in column a a series of 10 dates (assume a few of them are listed more than once) - also format column a for dates. column b has 10 values ranging from 1 to 10 - column b is formatted for numbers. if i create a xy scatter plot, and format the x axis to be dates, they plot all weird. it looks like the xy scatter plot converts the dates to numberic values, and then formats them back to the wrong dates.