+ Reply to Thread
Results 1 to 3 of 3

Offsetting data points so error bars don't overlap

  1. #1
    Registered User
    Join Date
    11-21-2020
    Location
    London
    MS-Off Ver
    mac version 16
    Posts
    3

    Offsetting data points so error bars don't overlap

    I am trying to display outcomes for a clinical trial on a line graph. The outcomes for the intervention and control group have error bars around them. Ideally I would like the values for the outcomes offset just a little bit so the error bars don't overlap. Ideally so that groups have a smaller distance than the outcomes. I attach a sample sheet with made-up data.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-21-2020
    Location
    London
    MS-Off Ver
    mac version 16
    Posts
    3

    Re: Offsetting data points so error bars don't overlap

    I think I figured out the offsetting by turning it into a scatter plot, but now the lines don't seem to connect anymore (see attached). Does anybody have a solution to this?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-21-2020
    Location
    London
    MS-Off Ver
    mac version 16
    Posts
    3

    Re: Offsetting data points so error bars don't overlap

    Okay figured this one out too- turned out to be the setting "show empty cells as: gaps" when I switched it to: "connect data points with a line" it worked. Hope this is helpful to anyone who has the same problem

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. (URGENT) How to set error bars for data points seperately?
    By nclz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-31-2013, 08:35 AM
  2. Replies: 2
    Last Post: 08-15-2012, 11:56 AM
  3. Replies: 2
    Last Post: 09-19-2011, 03:42 AM
  4. Chart issue with Vertical Error bars past 21 plot points
    By maacmaac in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 11-02-2010, 09:45 AM
  5. [SOLVED] excel should let you vary error bars for individual points
    By CRC in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-05-2006, 06:52 AM
  6. Error bars overlap and are indistinguishable
    By hadley in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-05-2006, 02:50 AM
  7. How do I make my data points not overlap in a scatter plot?
    By sfdc in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-29-2006, 11:35 PM
  8. [SOLVED] off-setting points of different series b/c error bars overlap
    By dothareggae in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-19-2005, 07:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1