Scatter Chart with Highlight Box to Group Data Points in Chart

A scatter chart helps to plot data with two or more variables. One great advantage that a scatter chart has is the ability to show a relatively large number of data points in a small area. However, as the number of points plotted within the same space increases, it sometimes becomes difficult to distinguish individual data sub-sets. One quick solution to group all the points within ...

Continue Reading

Scatter Chart with Highlight Box to Group Data Points in Chart

How to Choose a Chart

Posted on 03 July 2009

How to Choose a Chart
How to choose a chart? Which chart would best fit the data set that I have? How do I choose the better chart type from Excel? Finding the right type of chart for the data set that you have can be a bit of a challenge. Given a set of seemingly equivalent alternatives, picking one chart over the other can turn out to be quite an interesting exercise. The chart chooser diagram can help you make a choice in situations ...
Continue Reading

Comments (8)

Excel Chart Types – Basic

Posted on 31 August 2008

Excel Chart Types - Basic
These are some basic chart types in Excel. You can play around with these by downloading the file here. Stephen Few, Data visualization Guru and author, mentions a few rules for creating charts on his website PerceptualEdge. Some good reads are: Practical rules for using colors in charts Godin’s Silly Rules for Great Graphs Stephan has, over the years, written on many facets of presenting data ...
Continue Reading

Comments     



Subscribe

Keep up with the latest stories - Delivered right to your inbox
feedburner

Translate

English flagItalian flagKorean flagChinese (Simplified) flagPortuguese flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagDutch flagHindi flagFilipino flagIndonesian flagThai flagTurkish flagPersian flag
treeemap software for excel