+ Reply to Thread
Results 1 to 2 of 2

Box Plot 2 or more variables

  1. #1
    Registered User
    Join Date
    08-19-2014
    Location
    Brasil
    MS-Off Ver
    2010
    Posts
    1

    Box Plot 2 or more variables

    Hello,

    I have an issues concerning box plot chart...
    I have several bank that give me nominal rate and liquid rate per region and per distributors! I would like to represent it in box plot putting the name of the bank with two box plot, one for the nominal rate and one for the liquid rate!
    For the moment I'm just drawing a rectangle from the lower rate to the highest for both nominal and liquid rates. It looks like this but it is not very good and very long to do!

    Capturar.PNG

    Thanks a lot for your help!

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

    Re: Box Plot 2 or more variables

    It looks to me like your starting point will be a floating bar chart: http://peltiertech.com/Excel/Charts/...ngColumns.html
    Following the Gantt chart links in Jon's article should help you see how to add the 1.44% target line as an XY series.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Semi-log plot with one y variable and two x variables?
    By jnnfr37 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-16-2013, 06:15 PM
  2. How to plot dataset depending on two variables in schattered table
    By teilnemer in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-10-2013, 12:13 PM
  3. Replies: 1
    Last Post: 06-20-2006, 08:45 AM
  4. How to plot a formula with two variables
    By Ali Baba in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-29-2005, 01:13 PM
  5. Plot 2 variables on Y axis
    By nemme in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-18-2005, 05:06 PM

Tags for this Thread

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