+ Reply to Thread
Results 1 to 4 of 4

superimposing onto a boxplot

  1. #1
    Registered User
    Join Date
    06-09-2013
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    2

    superimposing onto a boxplot

    I created a box plot for my data from a marked line chart (it includes, min, max, 25, 50, 75 percentiles and has a box showing the IQR (25-75 %tile). I also would like to show the mean on this graph, but when I add that data, the box no longer includes the correct data. Is there a way to add this and/ or superimpose a second chart with only means on top of this one?

  2. #2
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    245

    Re: superimposing onto a boxplot

    Yes. In the past, I have set the axis-values constant, then copied and pasted the other chart (to get the axes the same size), then selected the mean data & formatted this new chart as no background color, no border, no axis color, etc., so it just floats above your other chart.
    <--- If you like the answer, press *.

  3. #3
    Registered User
    Join Date
    06-09-2013
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    2

    Cool Re: superimposing onto a boxplot

    Thanks- it worked!

  4. #4
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    245

    Re: superimposing onto a boxplot

    Awesome, glad to hear it! Please remember to mark your thread when you have a solution you're happy with, and if you feel so inclined, press the * to the left to add to my reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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