As Luke points out, it's very easy to set up multiple data ranges. They can
all be linked to a central table, so they update when the underlying data
changes. The drawbacks? You use extra worksheet space. This hasn't been a
practical issue since we stopped using COBOL in the mid-80s. The benefits is
that you can make ranges which are optimized for charting, display, and
further analysis, and save the time it might take to try to make one range
fit all needs.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"JAbels001" wrote in message
...
No can do... They must return the values they are.. "N/a" or "No Data"
must
come up in order for my workbook to meet other criteria... Suggestions?

"Luke M" wrote:

Have your formulas return the #N/A error
Example:
=IF(A1=B1,A1+B1,NA())

XL graphs ignore the NA error, as it is, by definition, not applicable.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"JAbels001" wrote:

I have several graphs put together from data on another tab, however
sometimes this data will come up "N/a" or "No Data" which the graph
recognizes as ZERO. Can this be avoided? I only want the graph to graph
numberical values. Please assist. Thanks!