+ Reply to Thread
Results 1 to 2 of 2

How to make a graph with multiple means with ranges.

  1. #1
    Registered User
    Join Date
    10-13-2018
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    1

    Exclamation How to make a graph with multiple means with ranges.

    Hi!

    I'm doing a medical research where i compare the improvement of a medicine. I extracted the data of multiple articles. This data consists means and the ranges.

    In the annexure i added an example of the desirable graph, which i created in paint.

    Can someone please explain to me how i can achieve this graph?

    Thanks in advance!

    Picture of the desirable graph: Help a med student out!.png

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: How to make a graph with multiple means with ranges.

    That looks to me like a basic XY scatter chart with a "category" vertical axis. Horizontal error bars would be used to indicate the range. I cannot tell if the vertical "error bars" have any meaning, or if they are just there marking the position of the average.

    I am not sure how familiar you are with creating charts in Excel. A few links to review:
    A basic introduction to creating scatter charts: https://www.excel-easy.com/examples/scatter-chart.html
    This one shows how to fake the vertical category axis: https://peltiertech.com/Excel/Charts...egoryAxis.html
    This one shows how to add the error bars: https://www.excel-easy.com/examples/error-bars.html Note that most chart types (except scatter) don't allow horizontal error bars, so most tutorials only show vertical error bars. When you add error bars to a scatter chart, you will have both vertical and horizontal error bars, and can display and/or format them separately.

    That should get you started.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. how to make line graph dynamic based on date ranges?
    By mikey42979 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-09-2016, 03:33 PM
  2. Replies: 2
    Last Post: 01-21-2016, 05:15 AM
  3. Replies: 1
    Last Post: 04-23-2013, 01:14 PM
  4. Make date ranges for graph (choose start and finish date)
    By zeko90 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-23-2013, 09:13 AM
  5. cumulative means graph
    By molemeister in forum Excel General
    Replies: 1
    Last Post: 05-12-2010, 04:21 AM
  6. [SOLVED] Macro to make a graph: help selecting the data ranges.
    By Isabel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2006, 11:35 AM
  7. graph multiple data ranges
    By lindy.coyle in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-10-2005, 09:50 PM

Tags for this Thread

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