Hi Bob,

Am Mon, 5 Feb 2018 02:36:08 -0800 (PST) schrieb Robert11:

Using the latest Excel. Probably should have stayed with Excel 2007, as it handled this without any problem.

I have a simple spreadsheet for my blood pressure.
Dates in one column, and the Systolic and Diastolic values in the next two columns.

The Dates I use in the data table are e.g., 15 Dec., 22 Dec.,
and then we go to: 4 Jan...etc.

Plots up fine as ling as there is no jump to Jan dates from the preceding Dec.
It doesn't know how to handle this transition, even though all the data is sequential.

format your x axis as text axis.
If that wouldn't help send your workbook to my email address and tell me
how many days or month you will show with your chart.


Regards
Claus B.
--
Windows10
Office 2016