1
$\begingroup$

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,

1 Answers 1

0

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.

  • 0
    Yes, i can make it as next power of 10, thanks for the idea!2012-11-13