How to change axis spacing for dynamic axis range?

[Rnkhch]

Hello,

My goal was to create an XY chart that grows automatically as more data is entered for each day of the X axis, and I succeeded. However, I cannot get the spacing between the dates in the X axis correctly, as you can see from the picture below:

There should be more gap between 7 and 33 vs 0 and 7 in order to correctly reflect passage of time visually.

I defined three names as follows:
Xasis=Excel!$D$3:INDEX(Excel!$D$3:$R$3,COUNT(Excel!$D$3:$R$3))
Sample1=Excel!$D$4:INDEX(Excel!$D$4:$R$4,COUNT(Excel!$D$4:$R$4))
Sample2=Excel!$D$5:INDEX(Excel!$D$5:$R$5,COUNT(Excel!$D$5:$R$5))

I would appreciate any ideas as to how I can fix this spacing. There will be additional data points for random days that could go to as high as 365 and 540, and it would be great to have nice spacing between the data points.

Thank you!

 

[Oaktree]

Change your chart type to XY Scatter and add solid lines to each series (right click on a data point and change the outline color).

 

[Jon Peltier]

As @Oaktree implied but didn't explicitly state. In a Line Chart, the X values are treated as non-numeric categories, so they are evenly spaced, independent of any actual numeric values. An XY Scatter chart treats the X values as numbers, and will space them proportionally to their values.

 

[Rnkhch]

Thank you guys! It worked very easily