I am trying to set up "empty" scatter plots that display counts on various dates when cells are populated with data.
When I select the date x-axis data it appears to the side of the Edit Series dialog box and the Select Data Source dialog box as dates, but the graph displays generic categorical values, 1, 2, 3 etc depending on how many values I have in my series.
I've search a number of forums and google for a similar situation but I'm having no luck.
When I select the date x-axis data it appears to the side of the Edit Series dialog box and the Select Data Source dialog box as dates, but the graph displays generic categorical values, 1, 2, 3 etc depending on how many values I have in my series.
I've search a number of forums and google for a similar situation but I'm having no luck.