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.