Graphing with proportional intervas on x-axis, line graph

[lifeseeker1019]

Hi there,

I'm simply trying to graph my data on a line graph in Excel. Please see the attached.

The issue is that the spacing on the x-axis is all equivalent. I want the space between the initial and 1st month to be very small while the space between 6 month and 12 month be larger.

So at the end of the day, the line will be kind of crunched down from the beginning and goes up at the 6 month data point.

Is Excel capable of handling such simple request?

Any help is appreciated.

[shg]

Change initial/1st/3rd/... to 0/1/3/6/12 and change the chart to a scatterplot.

[lifeseeker1019]

thank you, it works. I guess I only have so many plot points to graph the data...

[shg]

You're welcome.