Negative or zero values cannot be plotted correctly on log charts. Only positive values can be interpreted on a logarithmic ...

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:• In the cells that were used to create the chart, enter only positive values (greater than zero).• In the chart, click the axis that you want to change, and then change the scaling option to something other than Log scale. (Options tab, Chart Elements group, Axes button).