+ Reply to Thread
Results 1 to 8 of 8

Whisker Chart w. Tails

Hybrid View

Number7stunner Whisker Chart w. Tails 02-17-2017, 02:30 PM
MrShorty Re: Whisker Chart w. Tails 02-17-2017, 03:33 PM
Number7stunner Re: Whisker Chart w. Tails 02-17-2017, 04:08 PM
Number7stunner Re: Whisker Chart w. Tails 02-17-2017, 05:05 PM
MrShorty Re: Whisker Chart w. Tails 02-17-2017, 04:51 PM
MrShorty Re: Whisker Chart w. Tails 02-17-2017, 05:40 PM
Number7stunner Re: Whisker Chart w. Tails 02-17-2017, 06:44 PM
MrShorty Re: Whisker Chart w. Tails 02-17-2017, 07:03 PM
  1. #1
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,412

    Re: Whisker Chart w. Tails

    I am not sure what you need help with. Before, I had assumed that you already had the scatter chart plotted, and you just needed help adding error bars to the scatter chart data. Was I correct before, or do you really need help with the whole chart creation? Starting from scratch (and disregarding the background colors), here's how I would build a simple scatter chart with horizontal error bars:

    1) Enter data into spreadsheet. Probably arranged something like:
    previous (x) -- current (x) -- y value -- difference
    1.5 -- 2.1 -- ?? -- =A2-B2
    next entries copy D2 down
    2) Insert chart
    2a) Select current (x) and yvalue columns
    2b) Insert -> Charts -> XY scatter chart -> markers without lines
    2c) Hopefully, excel will correctly see that the data is arranged in rows. If not, Clock "switch row/column". If Excel completely fails to see the x and y columns correctly, then enter the source data dialog and fix the data series.
    3) Add error bars (see help file in post #2)
    3a) Select data series
    3b) Layout->Error bars
    3c) delete the vertical error bars
    3d) Format horizontal error bars -> specify value -> use column D for the positive error bar values.

    Where do you get stuck?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  2. #2
    Registered User
    Join Date
    02-25-2016
    Location
    Florida
    MS-Off Ver
    2013
    Posts
    43

    Re: Whisker Chart w. Tails

    I got it! Thanks. I have a follow up. If I wanted to then add shaded areas. Like -2 to -3 was bright green, and 2-3 was dark red. What would I do there? Here's what I got so far!
    Attached Files Attached Files

+ 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. [SOLVED] Heads and Tails Macro Separate Column for Head; Separate Column For Tails
    By rmccain in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-24-2016, 05:11 AM
  2. Box and whisker chart, source from table
    By bradleyisaac in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-10-2015, 10:45 AM
  3. How do I plot multiple data sets on a whisker chart?
    By Zahra in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-19-2012, 11:11 AM
  4. Box-and-whisker chart (box plots)
    By James in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 08-07-2011, 01:01 PM
  5. Bar chart with whisker
    By kvonm in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-12-2006, 11:19 PM
  6. In a t-test, what are tails?
    By Dave in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-28-2005, 09:05 PM
  7. box-and-whisker chart
    By Jan Heijs in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-10-2005, 09:06 AM

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