I am trying to create a simple scatter plot with numbers (between 0 and 6) on the vertical axis, and dates (in mm/dd/yyyy format) on the horizontal axis, with a data point for each day from 08/01/2007 to 03/31/2008.
Here is what it my chart looks like:
As you can see, the horizontal axis begins with 6/17/2007 and ends with 6/1/2008 even though I am only providing data for 08/01/2007 to 03/31/2008. Additionally, the minimum and maximum bounds are set at 39250.0 and 39600.0 respectively for whatever reason.
How do I make this a chart that is actually displayed logically (ie not displaying dates in which I have no data for and being able to display logical tick marks (like the first of every month)?