Trying to scale my horizontal axis for a line graph??

[Eric1983]

I am working on the Treasury Yield Curve. (Line Graph)

My data on the horizontal

1m, 3m, 6m, 1y ... 30y

The problem I am having is that the distance between these are spread out the exact same. (I want them to be scaled- shorter distance from the 1m to 3m and a longer distance between 10 and 30 year.

Is there a way to manually adjust the gridlines?? or similar to get the scale I am looking for.

 

[GlennUK]

You need to have meaningful values for the horizontal separations, and then you can create an X-Y scatter chart.... you can still specify a line for the series.

 

[Eric1983]

So, I switched to a Scatter and checked the horizontal axis format options once again...

Is there a custom format? (so, I can keep the months / years after each ie. 3 months) or should I just have the numbers .3 .6 1 2 3 5 7 10 20 30

I appreciate your help.

 

[Andrew Poulsom]

You need the number of months on the x axis - 1, 3, 6, 12, ... 360.

 

[Eric1983]

Worked Perfectly! Thanks for Your Help. E