LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Wazooli
 
Posts: n/a
Default error bars when breaking the y-axis

Jon - I think this question is directed towards you. I have implemented a
version of your broken y-axis scheme. My data looks like the following:

sample average avedev
negative control 0.36252361 0.029793573
sample 1 3.265795907 2.878954305
sample 2 0.149275395 0.035304333
sample 3 73.57998574 2.237144009
sample 4 0.346937718 0.02837823
sample 5 4.636386221 0.089703534
sample 6 709.7039626 16.33742397
sample 7 1.157628293 0.667009325
negative control 0.494505996 0.051731733
RNase A 1pg/ml 1.604749215 0.106664119

As you can see, most of the sample are in the 0-5 range, but nos. 3 & 6 are
way out. The question I have is how do I plot the avedev as error bars when
I have broken the y-axis? I need to adjust these values to reflect the
change I have made to the average series. I have the y-axis broken twice,
with the sample #3 bar broken once and the sample #6 bar broken twice. I
also did not use the method you use to calculate the midpoint of the bar for
placement of the break; rather, I eyeballed it.

 
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
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM
interchangine catergory and values axis 100green Charts and Charting in Excel 2 December 16th 04 09:06 PM
catergory on the X axis; values on the Y axis 100green Charts and Charting in Excel 1 December 15th 04 07:06 PM
Y axis, need varying units NTE Charts and Charting in Excel 10 December 13th 04 06:34 PM
Linking Axis Labels Neil Charts and Charting in Excel 2 December 5th 04 09:04 PM


All times are GMT +1. The time now is 02:09 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"