I'm trying to create a chart for work. I have the chart with about ten years
of dates. A worker will fill in the data (byte count) as the Y-Axis data.
The dates are the X-Axis data. I have the dates already filled in (from
1/1/2008-12/31/2029).

My question is whether or not Excel can only show data with the dates that
have data. I already have it connect when a data point it missing, but I
want it to also not show the last 28 years, if I only have the first year of
data filled in.

I would rather not have to select new series data every day.