Take the 2-minute tour ×
Mathematics Stack Exchange is a question and answer site for people studying math at any level and professionals in related fields. It's 100% free, no registration required.

I would like to draw Histogram chart comparing two values, 1) BE Candidates, 2) MCA Candidates. The values pairs example.

  1. BE Candidates (5) - MCA Candidates (100)
  2. BE Candidates (500) - MCA Candidates (20)
  3. BE Candidates (15) - MCA Candidates (16)
  4. BE Candidates (3) - MCA Candidates (22)

I would like to find a maximum Y axis value based on BE Candidates and MCA candidates count. Is there any calculation to find the maximum value to be set, so that the difference between those two values will be better visible?

Please advice, Thank you,

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

The maximum needs to be at least 500 so you can get all the data on. Any higher and you lose resolution, so 500 (or maybe just a little higher so the bar stops) it is. You are right that it will be hard to see the smaller values then.

share|improve this answer
    
Thanks for the reply buddy, i need some mathematical calculation to compute the value. Do you have one based on provided values? Charts used to do this. If you give all values lesser than 10, it will take 10 as maximum suppose. If we give 1, 400, 200, 150, it may take 400 or more as maximum. I need a formula to find this. Please advice, Thank you. –  Paramasivan Samuttiram Nov 13 '12 at 14:14
    
@ParamasivanSamuttiram: You can just take the max and min of your data. Alternately, you can round it up to the next power of 10, or to the next 1,2, or 5 times a power of 10. The hard part is deciding clearly what you want-once that is in place it can be turned into a formula. –  Ross Millikan Nov 13 '12 at 14:39
    
Yes, i can make it as next power of 10, thanks for the idea! –  Paramasivan Samuttiram Nov 13 '12 at 20:18
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.