+ Reply to Thread
Results 1 to 4 of 4

Help with Box Plot (Box and Whisker) - trying to overlay a marker on the chart

  1. #1
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Help with Box Plot (Box and Whisker) - trying to overlay a marker on the chart

    I didn't get any help in the chart forum - so I thought I'd post here in case anyone has any ideas...

    I'm new to box plots. No problem creating a boxplot chart - but I want to overlay a single set of scores so that those scores are marked with an X or something (so someone could see where their score is in a cohort). I've tried to attach a mock xls which shows what I'm trying to do – BUT the attach icon isn’t working (I’ve tried both Chrome and Edge). So I’ve attached an image of the mock sheet instead.

    snip_20170408120944.jpg

    Really appreciate any help.

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

    Re: Help with Box Plot (Box and Whisker) - trying to overlay a marker on the chart

    Jon Peltier's tutorial includes adding a line/scatter series for the mean, which should be easily adaptable to adding the "myscore" values as a line/scatter series: http://peltiertech.com/excel-box-and...ams-box-plots/
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,223

    Re: Help with Box Plot (Box and Whisker) - trying to overlay a marker on the chart

    You need data values in center of graph. If yes
    >click on graph range
    >select "Add data lable"
    >click on values > Right click > Select "Format data lable"
    >In Lable option > click on "Center"
    >Click "ok"


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  4. #4
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Re: Help with Box Plot (Box and Whisker) - trying to overlay a marker on the chart

    Thanks for the responses.

    @AVK. Perhaps I wasn't clear. what I need is a single score to be marked against a box chart. i.e. if you were a student in a class - to show where your exam score was compared to everyone else that took the exam.
    @mrShorty - Thanks that link looks helpful. I'll read through it and see if it helps me address the challenge

+ 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. box and whisker plot x axis
    By DominikaM in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-25-2017, 08:52 PM
  2. Box and Whisker Plot
    By marshymell0 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-08-2013, 10:32 PM
  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. Excel 2007 : Error in making a box-and-whisker plot
    By flyingcurry in forum Excel General
    Replies: 3
    Last Post: 12-01-2011, 08:49 AM
  5. box whisker plot
    By flyingmeatball in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-09-2007, 11:11 AM
  6. [SOLVED] how do I create a box-plot (or whisker plot ) graph?
    By raal in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-08-2005, 04:05 PM
  7. How do I draw a Box and Whisker Plot in Excel?
    By angela268 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-24-2005, 04:06 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