It actually starts where your data starts, 12/22/21, and ends at 12/30/22, just a little ahead of your last input date value.

I am seeing what you're seeing in adjusting the min and max axis values. The trick to figuring that out is to open Excel, type those two numbers in there (44552.0 and 44925.0) and then apply a date numeric style and you'll see they are 12/22/21 and 12/30/22. If you want to adjust your chart to start at say, March first, you can use Excel to convert that date to a number value (44621) and plug that in.

That said, as Guessed mentioned, this whole process is just easier in Excel, especially with something with as many values as you have. Also, you set your top cutoff at 3500, but you have values that go over 30,000 in the early part of your chart which aren't going to show up.

Dates as an axis in either program are going to be processed, by default, in whichever way they are going to chunk up best. I plopped your data into Excel, and it defaults to labeling by month, which may not correspond to your exact dates. In Excel there's an easy adjustment to the axis where you can change it to a "text axis" - at least in 365 which is what I have. I can remember in old versions having to put an apostrophe in front of the number to get Excel to treat the date label as text.

You also had a row of data below your date-labeled rows that was much smaller in value. I removed that for the Excel mock-up attached.

Attached Files

chart_excel.xlsx (93.0 KB, 3 views)