 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
09-09-2005, 08:05 PM
|
|||
|
|||
|
irritating warning for negative data on log charts
I know perfectly well that I can't plot negative values on a log chart. That
doesn't mean that my data doesn't have negative numbers in it. Is there any way that anybody knows to disable this irritating message? My productivity drops 100% because every time I scroll around in a sheet that happens to have a negative number on a log chart somewhere, this irritating dialog pops up. I don't want to have to build my own log charts that ignore negative numbers (I could, but what's the point of a built-in log chart if you can't use it). I don't want to have to write formulas for cells to make the offending negative value "invisible" to the chart (we've tried dozens of ways, and they all fail to be user-friendly at some level). What I want is to tell Excel that I'm smart enough to know that when the chart has a hole in it, it's because it couldn't plot the data. What's so hard about that? This has frustrated me for years. Can anybody help? -- Roger Stout, PE Senior Research Scientist ON Semiconductor 
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
