View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default error message for phantom chart with log scale


One way is to SaveAs the Workbook under a different name, then from the new
workbook, delete the charts one at a time until yoy no longer receive the
message. Make sure you keep track of the charts that you delete so you will
know the name of the one that applies. Also, I would start deleting based on
the ones have zero values in their data series.

"Greg" wrote:

When I try to save my Excel file I get an error message that says that
I can't have data with values of zero on a chart with a log scale. The
problem is that there are no charts in the workbook with a log scale.
How can I find out which chart is causing this error message?

Greg
Olympia, WA