Problem with the Date under the X-axis

"My guess is the last four are not correct. How they got that way I do not know. If this is the problem, you can correct them there or redo the chart from scratch."

Bingo!!!

Selected the X-Axis then deleted the Orange range. It now looks like this:

And, the Date range looks like this now!

Thanks for the quick reply!

Let me answer the "low hanging fruit" question and make some comments:

1. Are you sure you want a category line chart for your data? Ans: No, I'm not sure. This is my first graph attempt. Started a couple months ago on it and it has been a learning exercise. (not necessarily the easiest one, either!) Learning how to do something new with an app almost never is.

2.The X-axis spacing between data points is equal regardless of the number of days between them. Reply: I've been looking at the spacing between dates and you're right. However, so far, the overall graph looks good, at least until one gets to the last four data days. I've noticed this problem before, though, and as new data is added the curve tends to smooth out properly, so that is good.

3.A scatter chart is the only true X-Y chart. Reply: Thanks for the input. I think I've read this before here while trying to troubleshoot.

4.To make a scatter chart, the X and Y data must both be in normal data cells, not the X in header cells like the other charts require. And you'll have to be careful about the years associated with your dates. Reply: I like the extra input. I was worried about how the December data point would mess up the graph if I changed anything. The first CDC confirmed variant case was at the end of December and I wanted to keep it accurate. Thought I might deal with it later, if needed. The other option I was considering was covering the Dates to Julian but didn't know how that would affect anything. This graph is being shared with non-scientific-type people so K.I.S.S. is helpful. I can understand scatter diagrams but the typical lay person, probably not so much. Also, "connecting the dots" with a line shows up well, but little dots with space between them don't have as much visual impact.

With regard to editing the dates or redoing the graph, this will take a lot more work. I'm still doing battle with trying to figure out the best way to capture the Table data and put it in the graph. It's been more of a trial-and-error process. Sorry, but just not as fast of a learner as I used to be. Also, selected the wrong computer in the original post; doing this on a MBP 2012, not the MP. Geeze, almost 10 years old now!

As for doing the more difficult part now, I did go to the sidebar and check what all the dates were, and they were all the same type (unless I missed something).

"Note: All spreadsheet dates in the table’s Date column are set as numbers to Align Right, for what it's worth."

Will check this out in some more detail but that, and re-editing the Table, will take some time.

(doing this in dark-mode now ... not as easy to do)

"It sounds like you looked at the format of the cells that have the dates but did you select the chart and look at what cells it is using for the X axis labels?"

Ans: No, I hadn't. BUT, I did now!

What happened was, when some rows were added to the Table, the darker black border had reproduced and separated the new rows. The work-around was to back up a row then add new rows. On the screen it didn't look any different.

Here is another screen shot:

So, if I delete the orange range and edit the blue range (if that is possible), click on the green check-mark, then perhaps that will fix the problem.

"That was what I was describing in my last post, how to check that. You will see an entire list of all the cell references it is using for the X axis labels. My guess is the last four are pointing to the wrong cells. It probably got messed up when you were adding new data to the chart."

Reply: Excellent educated guess! Very helpful.

What I would like to have is a line drawing of a Table and a Graph with the terminology of various items identified. Ditto with the side column. Something that can be printed on paper (US letter or A4) and have as a reference on the desk. Did this once with Final Cut Pro and it was very helpful, but that was a few years back and, unfortunately, the layout has changed. Good job for an AutoCad person.

Having got the original problem solved, I'll go to work on the Scatter Chart.

The appearance is different from what I thought it would be; didn't know a line could connect the dots. Thought it would look more like a shot-gun approach.

Currently, the last few graph data-points are not as steep as they should be because for a rise of 1,000 they are only one day and two days apart, compared to near the beginning which is over two weeks fora rise of 75, yet the spacing is the same. The slope should be much greater than what is currently looks like, more like on your scatter diagram.

Don't have time to work on it now but will tackle it.

THANK YOU VERY MUCH FOR SOLVING THIS AND ALL THE EXTRA HELP! It was a great learning experience! (Should make a video of this!)