Line Graph and Getting a Line from Zero To First Point

[jaclrsen]

I have a line graph per the attached document and as you will see the first dot for 1 is at 13.

I was wondering, is it possible to get a line from 0 to 13 on this graph? For example, a pink line drawn from the gap between 0 to 13 indicating the first jump?

Thank you,

JL

[Melvinrobb]

The attached should work. For future reference, you need to position the axis "on tick marks".

[jaclrsen]

Hi Melvinrobb, Thank you for your help and sorry to sound like a dunce. However, what did you change and how do you position the axis "on tick marks"? Also, is this possible to do without adding a zero on the bottom axis? For instance, the bottom axis starts at 1? Thank you for your help, JL.

[Melvinrobb]

1. Right click on the axis and select "format axis". At the bottom you have the option to select where to position the axis.
2. If you delete the "0" in A2, it might work. That is as close as I know how to get to what you are looking for.

[jaclrsen]

Hi Melvinrobb, Thank you so much for your help as I was able to accomplish what I set out to do. I deleted the zero and got what I needed. Thanks. Your help is very much appreciated.

[Andy Pope]

Or use a xy-scatter rather than a Line chart