All of us will agree that our favorite magazines will not be interesting enough without visuals or pictures. Pictures develop user interest and also make it easy for the author to convey the message. Charts in MS Excel play a similar role. Charts help us in understanding the information better, make data analysis simpler and above all capture the readers’ interest because of their visual appeal. In this series on Excel Charts, we will cover below topics:
- Types Of Charts In Excel
- Choosing The Correct Chart Type
- How To Create Excel Charts
- Basic Excel Chart Formatting
- Advanced Excel Chart Formatting
Excel has a variety of charts to help us perform our analysis with ease. The most important chart types in Excel are:
Column charts are “comparison charts”. Column charts are used when we want to compare different values. Column charts give a clear picture of the highest, the lowest value also and the intermediate values.
Line charts are used when we want to show the behavior of values over a period of time. Line charts are often used to depict market trends and revenues over a period of time (5 or 10 years). Line charts can help an organization in planning & forecasting.
Pie charts are used for understanding the contribution of each value to the total. Pie charts are used for comparison and for understanding as to which value holds what percent of the total share. For e.g It can be used by the sales organizations to understand which product accounts what share/percentage of the total sales.
Bar charts are also comparison charts but they are used when we want to compare many different values. For e.g. Bar charts can be used by organizations to compare the sales of different products in a particular year.
We will learn more about when to use which chart, how to create charts in Excel and formatting of Excel charts in next tutorials.