Excel Charts are great but there are so many to choose from that sometimes its hard to decide which one goes well with your data.

The Infographic below (scroll down) helps you decide which Excel chart to use based on the data that you have and message that you want to convey.

EXCEL COLUMN CHART: Use this Chart if you have less than 12 data points & want to show trends.

E.g. Monthly or Annual data points Click Here To Get Our Free Excel Chart Templates

EXCEL LINE CHART: Use this Chart if you have more than 12 data points & want to show trends .

E.g. Historic results or Statistical data Click Here To Get Our Free Excel Chart Templates

EXCEL PIE CHARTS: Use this Chart for component comparisons only (Sums to 100%)

E.g. Market share Click Here To Get Our Free Excel Chart Templates

EXCEL BAR CHARTS: Use this Chart if you have long names and want to compare

E.g. Competitor analysis Click Here To Get Our Free Excel Chart Templates

EXCEL SCATTER CHART: Use this Chart if you have 2 variables and want to show a relationship.

E.g. GDP v Income or Speed Limit v Accidents Click Here To Get Our Free Excel Chart Templates

EXCEL BUBBLE CHART: Use this Chart if you have 3 variables and want to show a relationship.

E.g. GDP v Income V Population (Size of bubble is the 3rd variable)  Click Here To Get Our Free Excel Chart Templates

*** Click on the image to enlarge or right click on the image to save image/target to your desktop ***

Excel Chart Template

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Create a Treemap Chart With Excel 2016  Treemap Charts are one of the many new Charts available only in Excel 2016.They are very visual as it can easily show you patterns, like based on your summary of sales grouped by month.The tree branches are represented by rectangles, wherein each rectangle's siz...
Win/Loss Sparklines When you have  a large data set with positive and negative numbers, a great way to visualize the trend is to add a Win/Loss Sparkline next to your data.That way you or the reader can easily spot the trends and patterns.To enter a Win/Loss Sparkline in Excel you firstly ne...
Dotted Line Organizational Charts You can create Organizational Charts in Excel using SmartArt which I go through in this post here:   Organizational Charts in ExcelYou can also extend this concept to create a Dotted Line Organizational Chart but we need to think outside the square a little bit to make this h...
100% Stacked Column Chart: Percentage Contribution... The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total.For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then thi...