+ Reply to Thread
Results 1 to 8 of 8

Whisker Chart w. Tails

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

    Whisker Chart w. Tails

    Hello,

    I was checking to see if someone knew how to make a type of whisker chart, horizontally, and with a tail to it. I have an example chart attached. Disregard the colors and stuff.

    I have data. I have the max and min, the current data point, and a prior data point. So with that I want to see where we are now relative to where we came from, within a stated range. Here's example data.

    Current: 2..1
    Max: 2.8
    Min: -3.0
    Prior Data point: 1.5

    Example.png

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

    Re: Whisker Chart w. Tails

    I do not understand how your data relates to the chart in your picture, so I don't think I understand all of what you are after. Are you talking about the red circle data series with the "horizontal error bars" in your picture? If those are the "whiskers" you are referring to, I use error bars to add that sort of thing to a chart https://support.office.com/en-us/art...5-864049a145f0
    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
    02-25-2016
    Location
    Florida
    MS-Off Ver
    2013
    Posts
    43

    Re: Whisker Chart w. Tails

    Thanks for the reply. The red dot is the current reading (color coded based on the side of the black vertical line). The line coming from the red dot is where the prior data point is coming from.

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

    Re: Whisker Chart w. Tails

    If you have not already, I would add a cell/row/column to compute the difference between current and prior, then add horizontal error bars to the series, using this helper cell/column/row as the values for those error bars.

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

    Re: Whisker Chart w. Tails

    Im still having trouble. I want to make a chart using 4 data points. The current reading. Lets call that 2.0. Last month the reading was 1.0. So I want the current reading to be a dot, with a tail from the prior reading. I want the range to be -2 and +2. I want it to be horizontally displayed. I know it has something to do with error charts, but cant seem to get it.

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

    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:
    Please Login or Register  to view this content.
    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?

  7. #7
    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

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

    Re: Whisker Chart w. Tails

    This tutorial shows how to add a shaded background to an XY scatter chart using a combination XY scatter + stacked area: http://peltiertech.com/shaded-quadra...scatter-chart/
    This one uses a stacked bar chart to add vertical bands: http://peltiertech.com/Excel/Charts/...ticalBand.html

    I would recommend trying either of those.

+ 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. [SOLVED] 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