Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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

No. The data is as shown above, no empty cells. Thank you.

  #2   Report Post  
Posted to microsoft.public.excel.charting
vandenberg p
 
Posts: n/a
Default Negative or zero values cannot be plotted correctly on log charts

NTE wrote:
: No. The data is as shown above, no empty cells. Thank you.

I think it is clear that the problem is caused by your error bars.
You say you do not get lower bars, this is because the lower
confidence interval covers zero so they are all negative.

Error would be computed as Y+/- = X +/- error.
Since X is very small it is easy to see how Y could be negative.
Probably the only error bars you could plot would be % choice on
the menu. This would keep the numbers positive since
the computation would be Y+/- = X * (1+/%). (Assuming you
keep % less than 100%)

The other choices are all absolute numbers which could
easily result in negative numbers for the lower limit.

Pieter Vandenberg
Reply
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 01:22 AM.

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"