Actually, it only starts and ends correctly because I manually set it. Add the x-axis back and edit it, change it to auto. That will then leave a monstrous gap at each end. Your version seems to be working, and mine used to in Word a long time ago.

Yes, I'm manually getting the right number from Excel, but surely there's an easier way? Why can't I input date values, since it's a date axis!

I know the large numbers don't show up, I'm not interested in things which have shot up in value, I want to see the higher end in more detail.

I thought they all used the same coding for the chart, so I didn't even consider using Excel.

The row of data below was just me calculating the change for that day out of interest and not intended for the graph.



*****************

Looking at your Excel version, thanks very much for that, can you help me with a few things?

What is in sheet 1?

How do I change the shape of the chart to fit on my 16:9 monitor? I was unable to shrink the height using the bottom middle little dot thing.

How do I see the title for each column when I'm down at the bottom of the data in sheet 2? Word kept the title at the top so I knew which column I was editing/looking at.

I added a few lines of data at the bottom of sheet 2, but it didn't automatically change the axis to include them in the chart.