This article explains how to use the REPT() function in Excel to create a dot plot like the one shown to the left. It really is very simple. In some cases, dot plots may be better than bar charts, particularly when representing tallies or small numbers of items grouped into categories. By their nature, bar charts imply that values are continuous, while dot charts are used for discrete counts.
How to Create a Dot Plot
This article explains how to use the REPT() function in Excel to create a dot plot like the one shown to the left. It really is very simple. In some cases, dot plots may be better than bar charts, particularly when representing tallies or small numbers of items grouped into categories. By their nature, bar charts imply that values are continuous, while dot charts are used for discrete counts.
Subscribe to:
Post Comments (Atom)
Posts
11 comments:
I've been trying to make a dot plot a while, this post has sorted it for me, nice one!
Great!! I never know that Exell can do that.
Sweet, given me something interesting to try at work today, nice one!
Good post.
Great, thanks for sharing.
I always reckoned I could make excel do just about anything, but then relalised I could not! This site is a God-send, and I will use it regularly.
What an excellent and simple thing to do! It is really nice to see such elegant solutions.
Nice post. You can also make similar ones that look like lollipops
Easy to go! You all post are very well described, It's really very easy to go with your tutorial.
There are lots of stuff to do with Excel. Sometimes we can't imagine that, we can do such things with excel too.
This is awesome! Thanks for sharing such a nice idea.
Post a Comment