I have used an IF formula to replace blanks, zeroes etc. with #N/A as I
thought charts ignored this. My source data is 2 columns as below displaying
as a line chart:

#N/A #N/A
0.20 0.0017497
0.40 0.0017613
0.60 0.0017538
0.80 0.0017459
1.00 0.0017397
1.20 0.0017358
1.60 0.0019809
2.00 0.0021619
#N/A #N/A
#N/A #N/A
#N/A #N/A

The #N/As are plotted as zeroes with #N/A displaying instead of a figure on
the X axis.

I need to get rid of the #N/As displaying on the X axis and have excel
ignore them on the chart. Any help greatly appreciated.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting