LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
NTE
 
Posts: n/a
Default Negative or zero values cannot be plotted correctly on log charts

Excel 2002 SP3.

This maybe a stupid question (I'm not a statistician or mathematician).

I have data that looks like this:

Na 0.032617
Cl 0.0265
Ca 0.000524
K 0.005523
Mg 0.0000823
PO4 0.00031
HCO3 0.001655

I am plotting it with categorical values on the xaxis and the numerical
value on the y axis. I am using a logarithmic scale for the y axis.

I am getting the "Negative or zero values cannot be plotted correctly
on log charts. Only positive values can be interpreted on a
logarithmic scale" message, which I see from the newsgroup is common if
there are zeros in the data. However, the data I am using does not
appear to be zero to me. All the numbers are positive, even if they
are small.

So why am I getting this message?

Thank you.
Nicole

 
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
Get Excel to accept negative values using time-format Marcus Ahlbäck Excel Discussion (Misc queries) 1 November 9th 05 11:19 AM
Formula to make Negative Values Positive & Positive Values Negative? mustard Excel Discussion (Misc queries) 4 September 26th 05 10:05 PM
suppress zero values in line charts? Cruickshank Brothers Charts and Charting in Excel 4 June 12th 05 04:28 AM
suppress zero values in line charts? cruickshankbrothers Charts and Charting in Excel 0 January 14th 05 10:27 PM
To get a lot of charts that contain different values in a minute Kevin Charts and Charting in Excel 0 December 28th 04 06:45 AM


All times are GMT +1. The time now is 08:47 PM.

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

About Us

"It's about Microsoft Excel"