Searching... Searching...

Total Subscribers Receiving Our Weekly Excel Lessons

+75,000

CLICK TO RECEIVE OUR FREE EXCEL LESSONS

Excel Chart Template Infographic

Email this to someoneShare on FacebookTweet about this on TwitterShare on LinkedInShare on Google+

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

Related Posts:

Add an Interactive Vertical Column in Your Excel L... With Excel Charts, it is very easy to create a Vertical Column in your Line Chart and make it interactive with a Scroll Bar!The reason why I do this, is to use the vertical column to highlight a s...
Thermometer Excel Chart Thermometer Charts are one of the many Charts you can create in Excel.  It does not really exist in Excel, however we can get creative and create our own.A Thermometer Chart gives you a good view ...
Create a Box and Whisker Chart With Excel 2016 Box and Whisker Charts are one of the many new Charts available only in Excel 2016 and were originally invented by John Tukey in 1977.They show you the distribution of a data set, showing the ...
Create a Pareto Chart With Excel 2016  Pareto Charts are one of the many new Charts available only in Excel 2016.They are very visual as it can easily show you the biggest factors in the data set, like seeing which issues are...
Searching... Searching...
Excel Rescue

DO YOU WANT TO GET BETTER AT EXCEL?
If so, join over 75,000 professionals who get career boosting, Free Excel lessons delivered on a weekly basis!

Click here to subscribe

Leave a Comment

Your email address will never be published. Required fields are marked with *

Comments