Results 1 to 2 of 2

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

  1. #1
    Join Date
    Feb 2012

    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.

  2. #2
    Join Date
    Feb 2012

    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

Similar Threads

  1. How to get Horizontal Error Bars in Excel 2007
    By Tarani in forum MS Office Support
    Replies: 3
    Last Post: 25-02-2012, 11:49 AM
  2. Replies: 1
    Last Post: 25-02-2012, 11:31 AM
  3. Replies: 4
    Last Post: 31-12-2011, 06:11 PM
  4. Adding scroll bars to images in excel sheet
    By arungiles in forum Tips & Tweaks
    Replies: 1
    Last Post: 05-08-2011, 04:37 PM
  5. Error while importing data to excel file
    By Rutajit in forum Windows Software
    Replies: 3
    Last Post: 08-05-2009, 12:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts