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

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Share on Google+

Google+

Related Posts

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 the most common. A Pareto chart, also called a sorted histogram, is a column...
100% Stacked Bar Chart A 100% Stacked Bar Chart is a great way to compare a percentage that each value contributes to its total. So if we have sales rep sales for three consecutive years, we can plot this on a graph and it will show us what each sales rep´s percentage breakdown is per year. DOWNL...
Clustered Bar Chart: Year to Date Sales If you want to compare your Year to Date sales and have category names (eg. products, business names, channel partners, sales reps etc)  which are way too long, then the Clustered Bar chart is the one for you. In the example below the category names relate to companies and I a...
Excel Sparklines with Excel Tables Did you know that you can include an Excel Sparkline inside an Excel Table? Well you can! To create an Excel Table you need to highlight your data and press CTRL+T See Tutorial Here Once you have your Excel Table you can add your Excel Sparklines inside one Column and us...