Plot x axis with dates with non standard interval

[jdmc45]

Hi,

I'd like to plot x axis with dates with non standard interval and then a cumulative total number on the y axis.

example data below, so the x axis isn't normally spaced as the number of days/time period between x axis isn't the same, so it's like a jumping graph over time

Date	CumTotal
01/10/2024​	2​
01/18/2024	6​
01/30/2024	17​

I am using Microsoft 365 MSO and all the tips are in other versions and also don't work, can you please help?

 

[saboh12617]

I am not sure to understand your problem. When i plot an X-Y Scatter graph with your data, the X axis spaces the dates accordingly to their position, so that the 18 january is closer to the 10 than the 30. Did you make sure Excel recognizes your dates as Date and not Text?