If you chart has X-axis for the future points you can enter =NA() for the
y-values of these points.
The dynamic chart approach is generally used when the user adds both x- and
y-values and want the chart extended.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"PS" wrote in message
ups.com...
Hello:

I have set-up a chart that utilizes the techniques described in
previous postings regarding Dynamic Charting within Excel (using the
non-VBA technique of data labels utilizing the Offset formula).

In a prior post a list member described the use of the NA() formula as
part of an IF() statement to eliminate non-blank data from appearing on
the chart if no data was present.

However I am now left with one issue that I need to resolve to make
this chart fully usable - being that my X-axis label shows the future
periods with no data (in fact I used the same formula and end up with
#NA showing on the X-axis where no data is present). Any suggestions
on how to resolve this issue?

Thanks,
Paul