Zhiyong Zhang's Psychometric Website
 
Home Control Panel Login Register Search Submit Logout About me Contact me
My Research
Google
Web
This Site
Home > My Research > Programs > Plot histogram in Excel - An easy way
Plot histogram in Excel - An easy way
2005-05-07          Read: 8161 times
Cite this page: (2005). Plot histogram in Excel - An easy way. Retrieved December 16, 2018, from http://www.psychstat.org/us/article.php/10.htm.
Plot histogram in Excel - An easy way
If you have a variable with a list of values like,
1
2
3
4
5
6
7
8
9
10
9
8
7
6
5
4
3
2
1
Maybe you want plot the histogram in Excel.  However, Excel doesn't plot the histogram for you automatically in plot menu.
One solution is to count the frequency first, then use the bar plot.
There is a trick to count the frequency. You need using the array method.
After you input the data, you need to input the formula like this
 =SUM(IF($B$2:$B$20<=2,1,0))
 =SUM(IF($B$2:$B$20<=5,IF($B$2:$B$20>2,1,0),0))
 4
 5
 9

After you type in the formual, push down SHIFT+CTRL simultanuously and then PUSH down ENTER button. Then the frequency will be calculated.

Now you can plot!

Submitted by: johnny
Add a comment View comment Add to my favorite Email to a friend Print
If you want to rate, please login first, or click here to register. Or you can use USERNAME: guest and PASSWORD: guest to log in.
Average score 0, based on 0 comments
1 2 3 4 5 6 7 8 9 10
Copyright © 2003-13 Zhiyong Zhang \'s Psychometric Website
Maintained by Zhiyong Zhang