What kind of graph would I use that shows a min (50), a max (180), an average or median that shows a line between the min and max (78), and a line for a value (65)?
I want the viewer to gauge where their score of 65 between the min and max scores and how far they were from the median or average. Also, can there be two different colors that represent before and after the median or average line?
I'm sorry if this sounds confusing!!
Thank you for any help!
This is my go-to source whenever I have an unusual charting problem. I'd be surprised if your exact requirement isn't already discussed here: http://peltiertech.com/Excel/Charts/
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
What you describe sounds to me something like a box and whisker plot. From dflak's source: http://peltiertech.com/excel-box-and...ams-box-plots/
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks