Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamically Scale Gantt Chart Time Scale Andrew Lavinsky Charts and Charting in Excel 2 January 31st 10 12:51 PM
chart error message / work sheet not open ? Ron Charts and Charting in Excel 2 July 17th 07 08:16 PM
Chart Wizard - Excel shuts down with no error message [email protected] Charts and Charting in Excel 0 October 12th 05 11:52 AM
XY Chart Labeler Error Message Phil Hageman Charts and Charting in Excel 0 October 3rd 05 08:25 PM
Receive an error message when try to add a chart to a workbook kysiow Charts and Charting in Excel 1 June 21st 05 12:41 PM


All times are GMT +1. The time now is 12:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"