Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
No. The data is as shown above, no empty cells. Thank you.
|
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Get Excel to accept negative values using time-format | Excel Discussion (Misc queries) | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
suppress zero values in line charts? | Charts and Charting in Excel | |||
suppress zero values in line charts? | Charts and Charting in Excel | |||
To get a lot of charts that contain different values in a minute | Charts and Charting in Excel |