I am trouble-shooting for an internal client. When he has zero values in a
log chart, he gets the following message:
"Negative or zero values cannot be plotted correctly on log charts. Only
positive values can be interpreted on a logarithmic scale. To correct the
problem, do one of the following: Enter only positive values (greater than
zero) in the cells used to create the chart, OR In the chart, click the axis
you want to change. On the Format menu, click Selected Axis. Click the Scale
tab, and then clear the Logarithmic Scale check box."

He wants to keep the logarithmic scale and would prefer a 3rd option in the
above message to be "Skip the negative or zero values"). He is getting his
data from another source, so re-formatting or modifying the information in
the table (to maybe a Null or blank value) to plot this way in the chart
needs to be a very simple task.

Does anyone have any good ideas around this.