![]() |
error message for phantom chart with log scale
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 |
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 |
All times are GMT +1. The time now is 07:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com