Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Chart/Source Data update problem | Charts and Charting in Excel | |||
Excel Charts - Data being Plotted beyond Primary X-Axis Scale | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |