How to make a bar graph that tallies the amount of times a number appears?
I need to make a graph that will tally the amount of times a number appears.
Ex:
Column A
4
3
3
3
4
4
5
4
9
5
So I want input this data in to a bar graph. (X)axis: Numbered 1-10 (Y)axis: Number of times the number appeared. So "3" appeared 3 times, "4" appeared 4 times, "5" appeared 2 times, "9" appeared 1 time.
Hopefully you can follow what I am asking. Does anyone know how to make a bar graph like this?
Frequency.xls
In short, Yes! It's called distribution.
Elegant Simplicity............. Not Always
you can use a pivot chart-put Raw in the row and value field areas and set the summary function to count
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks