+ Reply to Thread
Results 1 to 3 of 3

Axis problem in my graph, please help.

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    11

    Axis problem in my graph, please help.

    so I am trying to make a box plot with an Excel 2007.
    here are my values.
    Min = 32%
    Q1 = 48%
    Median = 57%
    Q3 = 64%
    Max = 88%

    I used this method to make the box plot.
    http://www.youtube.com/watch?v=wvR3q41Pneo

    however when I graph it excel just goes full retard on me and ADDS the percentages... so I get something like a 300% maximum. My maximum is 100%, of which my observed data only goes as far as 88% of the 100%, not 300%. why is excel doing this? I tried finding a way to set everything max 100% but what excel does is just cut off my data at the 100% mark so half of my data is missing.
    please help me or show me another way of doing a proper of doing box plot.
    thank you for your time.

  2. #2
    Registered User
    Join Date
    11-14-2012
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Axis problem in my graph, please help.

    can anyone help? surely in an Excel help forum, at least 1 person knows how to do a proper boxplot.

  3. #3
    Registered User
    Join Date
    11-14-2012
    Location
    london, england
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Axis problem in my graph, please help.

    please, I am still stuck on this issue, any help would be appreciated.

+ 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