I have a spreadsheet I would like to chart for water analysis done by my
office. In some of the cells are N/A instead of values. I have tried
charting with the "N/A" left in and with a blank cell. Both don't work
very well. Could you help me smooth out the line chart? Below is an
example; the database is much larger:

Sample Number Ph Cl FL
GP050001 7.50 1.37 N/A
GP050002 6.50 N/A .30
GP050003 7.40 0.05 N/A
GP050004 7.50 0.11 .45

Also, the data categories are substantially different. I would like to
group all categories by displaying multiple line charts to help
establish relationships (if any). The Ph range is 6.5 - 8; Chlorine is
anywhere from trace to 1.4. So, you can see that the data is not within
the same range. I am sure there is a way to display the range for Ph
on the left "X" vertical column and to display a range for the Cl on
the right. Could you help me through that process please? I look
forward to it,

JW


--
willisj
------------------------------------------------------------------------
willisj's Profile: http://www.excelforum.com/member.php...o&userid=28685
View this thread: http://www.excelforum.com/showthread...hreadid=483687