Three possible approached:
1) In the cells with missing y-values enter =NA(). This displays as #N/A but
is ignored by the chart engine. You could use conditional formatting to
'hide' the #N/A

2) A dynamic chart
http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html
http://office.microsoft.com/en-us/ex...098011033.aspx
http://people.stfx.ca/bliengme/ExcelTips/Dynamic.htm

3) If using Excel 2003 (or 2007)
Turn your data into any Excel "list" (or "table" in XL 2007)
A chart made from a vertical list is automatically dynamic
For more see
In Help, search with Create an Excel List
or visit this site
http://office.microsoft.com/training...RC010801391033

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Rubbs" wrote in message
...
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.