+ Reply to Thread
Results 1 to 5 of 5

How to add add points on boxplot

  1. #1
    Registered User
    Join Date
    11-20-2020
    Location
    greece
    MS-Off Ver
    2016
    Posts
    3

    How to add add points on boxplot

    Hello,

    i recently created a boxplot using excel for 18 years for all 12 months. i now want to the existing boxplot i created, to add 12 points 1 for each month but i cant do it.
    can someone help me?

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

    Re: How to add add points on boxplot

    I'm confident we can help you, but you will need to give us more information. Are you making the box plot from the build in specialty chart type (which may not have any flexibility to add additional series) or are you using the "old-fashioned" method of using a stacked column/bar chart?
    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-20-2020
    Location
    greece
    MS-Off Ver
    2016
    Posts
    3

    Re: How to add add points on boxplot

    i attached the excel.. i did it the chart type way.. so if you see i have my boxplot and at the bottom i have 12 points Month-price that i want to add to my diagram
    Attached Files Attached Files

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

    Re: How to add add points on boxplot

    One thing I would do is to transpose your additional data so that it is oriented the same as the main data (months in ascending order in a row with the corresponding follows in the row beneath). It may not always be necessary, but I find it helpful to be consistent with the way my data are arranged -- in this case, have all data arranged in rows.

    It's not clear to me what you mean by "add these points to the diagram".

    If you mean that you want to add them to the data so that they are included in the chart's data analysis, copy and transpose the new data into row 21 and extend the chart's source data so it includes row 21. Because that seems so trivial, I am guessing you want something else, but I include this for completeness.

    If you mean that you want to add these as a separate "data series" (probably as a line chart type so that you get a marker at these points), then I don't think that works in the new specialty chart types. This effectively creates a "box plot + line" combination chart, but as I understand it, Excel will not allow you to make any kind of combination chart with a box plot specialty chart. If that proves to be the case, then I would suggest that you make the chart "the old-fashioned way" -- as a stacked column (+line for the extra data series) chart. This tutorial should walk you through the process: https://peltiertech.com/excel-box-an...ams-box-plots/

  5. #5
    Registered User
    Join Date
    11-20-2020
    Location
    greece
    MS-Off Ver
    2016
    Posts
    3

    Re: How to add add points on boxplot

    thanks for the reply ,yes, i wanted to add the other values separately as points.
    i tried the chart type way and it didnt work . so i have to do it the old fashioned way..
    thanks again

+ 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. Hiding Mean markers and Inner points for Boxplot chart by macro
    By Deergha Jain in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-15-2019, 05:18 AM
  2. Need help with boxplot
    By SammyBarc in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-07-2019, 01:45 PM
  3. Boxplot
    By tennisbuck in forum Access Tables & Databases
    Replies: 0
    Last Post: 12-24-2013, 10:17 PM
  4. superimposing onto a boxplot
    By lynnelliot in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-17-2013, 07:41 AM
  5. Boxplot Problems?
    By johnmw1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-04-2010, 05:39 PM
  6. i need add-ins to do Boxplot ((Please))
    By Monta421 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2005, 07:01 PM
  7. need help in stats - boxplot
    By in need of stats help in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-05-2005, 06: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