| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
negative/zero values on logarithmic plot warning
Hello all,
I realize that a negative or a zero plot on a logarithmic scale is meaningless. However, many times I'm working with data that is full of noise an non-ideal, i.e. it contains zeros and/or negative values. I still would like to plot them on a logarithmic scale. Excel does this quite well and ignores the negative/zero values on the chart. However, IT PRODUCES A WARNING EVERYTIME I TOUCH THE CHART! I make tons and tons of these graphs, so in order to save what little sanity I have remaining, I must find a way to turn this warning off. Please help me. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I determine the slope of a logarithmic scale data plot? | Charts and Charting in Excel | |||
| How do I plot chart with negative value using Logarithmic Scale ? | Charts and Charting in Excel | |||
| How do I limit a logarithmic plot scale to other than a full deca. | Charts and Charting in Excel | |||
| Disable warning for negative numbers on log scale plots | Excel Discussion (Misc queries) | |||
| irritating warning for negative data on log charts | Charts and Charting in Excel | |||
Threaded Mode
