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