Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Need help to add error bars in every data point of Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 25-02-2012
Member
 
Join Date: Feb 2012
Posts: 13
Need help to add error bars in every data point of Excel

I am busy writing a thesis and am plotting some data using the clustered column graph. I have 5 values on the X-axis (time in days.. 0-4), and for each of these X-axis values (days) I have 3 Y-values (high, medium, low dose observations). The problem is that each Y-axis value is a mean, and has a unique standard error of the mean (SEM). However, I can't find a way to make unique error bars for each data point. Instead, it will only allow me to enter 1 custom error bar value per dose observation over time. I feel like this is doable, but I just can't figure it out. Perhaps I just need to use another graph format? I feel like there is something really obvious that I am missing. I don't know if this is clear, but was wondering if anyone can help. I really don't want to have to draw these error bars in using powerpoint. I can elaborate if need be.

Reply With Quote
  #2  
Old 25-02-2012
Member
 
Join Date: Feb 2012
Posts: 13
Re: Need help to add error bars in every data point of Excel

Disregard, answered my own question. For those that are interested, instead of typing in a single entry as a custom value, you can highlight the entire range of SEMs and the chart allocates them accordingly. Hope this helps
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Need help to add error bars in every data point of Excel"
Thread Thread Starter Forum Replies Last Post
How to get Horizontal Error Bars in Excel 2007 Tarani MS Office Support 3 25-02-2012 10:49 AM
Want help to draw a circle in a graph via point data and axis in Excel DEvOTeEL MS Office Support 1 25-02-2012 10:31 AM
Microsoft Office Excel cannot create or use the data range reference because it is too complex Error Finian-- MS Office Support 4 31-12-2011 05:11 PM
Adding scroll bars to images in excel sheet arungiles Tips & Tweaks 1 05-08-2011 03:37 PM
Error while importing data to excel file Rutajit Windows Software 3 07-05-2009 11:38 PM


All times are GMT +5.5. The time now is 02:16 PM.