Logarithmic Scale - Suppress Error Messages when Negative/Zero Values 1

[jmgibson]

I'm graphing data using a Logarithmic scale. I do have negative values, and I realize these aren't allows, and I'm okay with the fact that Excel just skips over them. But, I get prompted with an error message that tells me that negative/zero values aren't allowed. Is there anyway to suppress these error messages from appearing?

 

[SkipVought]

Hi,

In the same manner that you were instructed to create a source data column for a second series for negative numbers as postitive values, create a similar one for only positive numbers, and DELETE the existing series that contains negative numbers.

ie, each source range should contain ONLY positive numbers.

Skip,
[sub]
Just traded in my old subtlety...
for a brand NUANCE![/sub]

 

[lionelhill]

you don't need to delete anything manually. A new column
=if(A1>0, A1, "")
will do it for you

 

[SkipVought]

"you don't need to delete anything manually."

He must manually DELETE the existing SERIES in the CHART or change the reference in the chart.

And your formula is exactly what I was referring him to in a previous post.

Skip,
[sub]
Just traded in my old subtlety...
for a brand NUANCE![/sub]

 

[lionelhill]

sorry, feeling thick today

 

[SkipVought]

Thumtimeth I feel thick ath well regarding variouth athpecth of my exthithtance.

Skip,
[sub]
Just traded in my old subtlety...
for a brand NUANCE![/sub]