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

Clustered Column Chart: 12 Month Trend An Clustered Column chart is used in Excel whenever you want to show a periodic trend that has around 12 data points.To create the Clustered Column you have to set our your data with the first column showing the periods and the second column showing the values.Below I sho...
Add High & Low Points in an Excel Sparkline Sparklines are a great way to visualize lots of data quickly.  Differentiating the High and Low points within the Sparkline pinpoints your strong and weak data points.To enter a High or Low marker you need to click inside your Sparkline which will activate the Sparkline Tools...
Process Map Using Excel If you want to show a process in your workplace then this can be designed using Excel´s Smart Art.There are heaps of Process Maps in Excel that shows progress from left to right, top to bottom, one way and circular.  Here is how you can insert a left to right Process Map usin...
Excel Chart Layouts When you create an Excel chart you can choose from 11 different custom Chart Layouts.This is handy if you are pressed for time and want to create a Chart with all its bells and whistles with a press of a button.From this selection you can show your Chart with or without t...