Are you using OFFSET formulas with COUNT inside to count how long the series
should be? This will prevent nonnumeric data from even getting into the
chart.

Keep in mind that the NA() trick only works for marker-type series (line,
XY, and I think Radar), not column and area types.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"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