Jon:
Thanks for your quick response you're feedback is helpful unfortunately
here is the dilema:
1) Its a Line chart with series data
2) I'm using a CountA formula within the Offset Formula
The labels for the X-axis are in a non-numeric format (e.g. Q206,
Q3/06)
So without the NA() trick I'm still getting an X-axis label but with no
data (thanks to the NA() function trick).
I'm hoping to iron out the wrinkles in this process since I have a
significant number of charts to update.
Also once I've worked out this issue would it be worth trying to learn
enough VBA to do this process vs. the time consuming process of
defining a large number of name ranges.
Thanks,
Paul
Jon Peltier wrote:
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
_______