Scatter Plot Axis Options

[Sako]

Hi everyone,

I need to do a scatter plot with the following data:
Month---Peter---Lyne
Jan-09 5 4
Feb-09 3 1
Mar-09 4 2
Apr-09 .......
May-09 .......
Jun-09
Jul-09
Aug-09
Sep-09
Oct-09
Nov-09
Dec-09
Jan-10

The chart looks great, except that is would start with
Nov-08, have no values/lines until the month of Jan-09.

Basically, I'd just like to remove all the months before Jan-09
because it only shows a blank, and I could use that space to show directly Jan-09 results instead of leaving 2 centimeters for previous months with no data...

I know Line Chart would be better, I find that the curves look better on scatter...

Please help

 

[tusharm]

Format the x-axis and change the min. value to whatever you want.

I'm curious as to what "the curves look better" means.

 

[Sako]

I tried using the Axis Options.

Minimum
Maximum
Major Unit
Minor Unit

However, the only values I can input are numbers (39448 etc.)
I want every X axis to be a month.
If I put Major unit to 30, then I would see some months appearing twice because some months have 31 days, other have 28.

 

[tusharm]

The XY Scatter chart does not incorporate the notion of time whereas a Line chart correctly handles the notion of "one month."