Excel Log Chart Error Message

[corycrum]

Hi All,

I had a workbook with a log-chart in it and received an error message that said negative and zero values cannot be plotted on a log chart. I don't need the chart to display a log scale on the y-axis so I removed the log scaling. The error message still appeared every time i saved the workbook.

I deleted the chart from the workbook and rebuilt the chart from scratch thinking this would fix the problem. It didn't work. I still get the same error message even with the new chart.

Does anyone know how to stop this alert? Do I have to rebuild the entire workbook from scratch?

Thanks!
Cory

 

[GlennUK]

How did you remove the log scaling? ( i.e. are you sure that you removed log scaling? )

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[corycrum]

I double clicked the axis, went to the scale tab, and unchecked the "Logarithmic scale" check box.

Is there another way to do it?

Thanks!
Cory

 

[corycrum]

I saved the file under a different name and the error stopped occuring.

I deleted the original file and changed the renamed file back to it's original name and the error started occuring again.

So, the solution is to rename the file to something different than the original name, and don't change it back. Why did this fix the problem? I have no clue, but it's a solution i can live with.

Thanks,
Cory