error message for phantom chart with log scale

G

Greg

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
 
J

JLGWhiz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
How to disable error msg "zero values cannot be plotted on log cha 0
I can create Publisher documents, but I can not open / read them. 0
Delete chart series 2
Absolute Scale of Chart Printout 4
Scale my excel chart 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Problem with Excel 2007 clustered column chart on log scale 1

Top