+ Reply to Thread
Results 1 to 3 of 3

How to fix plot distribution

  1. #1
    Registered User
    Join Date
    11-23-2021
    Location
    New York
    MS-Off Ver
    Office 365 for Mac
    Posts
    2

    How to fix plot distribution

    Hi everybody,

    I want to fix the distance between 2 dots on a forest plot in order to be consistent with the height of the lines.

    Do you know how to do it?

    Thanks,

    JBCapture d’écran 2021-11-23 à 09.49.41.png

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

    Re: How to fix plot distribution

    It is difficult to be specific based on a picture. Your picture (and other Forest plot descriptions) look like a basic "dot plot". Most tutorials I see propose using a bar + scatter combination chart for building these kinds of charts (https://www.statology.org/forest-plot-in-excel/ for example). The bar chart portion of the combination chart provides the vertical axis labels and the scatter chart portion plots the dots and "horizontal error bars". Since the dots are a scatter chart, changing the vertical position of the dots should be as simple as changing the y value assigned to each dot. The corresponding axis label will not follow, but perhaps that is not of concern.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    11-23-2021
    Location
    New York
    MS-Off Ver
    Office 365 for Mac
    Posts
    2

    Re: How to fix plot distribution

    Thanks, I found the way to manage it.
    JB

+ 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 plot frequency distribution graph with 2 distribution plots
    By escpolina in forum Excel Charting & Pivots
    Replies: 18
    Last Post: 08-16-2017, 10:22 AM
  2. Looking to plot Distribution chart of salaries by grade.
    By iceman00 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-13-2016, 04:18 PM
  3. [SOLVED] Plot a Normal Distribution Bell Curve
    By Matt1998 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-29-2014, 10:25 AM
  4. I need to create a distribution plot that sums values
    By Calvin Buchanan in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-13-2013, 03:17 PM
  5. Frequency distribution plot
    By mmmd_yaseen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-07-2010, 07:35 AM
  6. Replies: 1
    Last Post: 03-12-2010, 03:07 AM
  7. How to create a distribution plot
    By Hertz1976 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2008, 02:48 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