Can you dynamically expand the time range to the series data added

[Rubbs]

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.

 

[Bernard Liengme]

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/newsgroups/dynamic_charts/index.html
http://office.microsoft.com/en-us/excel/HA011098011033.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/training.aspx?AssetID=RC010801391033

best wishes

 

[Rubbs]

Ok, so I've got it so that it will dynamically add the new data to the chart,
but now I have a different problem. If I try to add information to a cell
and it isn't continuous, then it won't update the chart. For example:

Data Date
123 1/1/08
234 1/2/08
1/3/08
243 1/4/08
1/5/08
...

I need it to be able to select up to 1/4/08 without selecting any further.
I know that if I add NA() to each of the blank cells in between the data
points, it will graph (and I can have it ignore those points), but I would
like to know if there is a way I can have it either select down to the latest
data point, or find a way to only fill in the blanks from previous dates with
NA(). I tried using an if statement, but apparently Excel can not return
NULL(A feature I'm not sure why wasn't included).

Anyone have any ideas?