Creating and Formatting Charts in Excel

Charts and visualisations are how data analysts communicate with the business. You may have seen presentations made by managers, CEOs and analysts etc. Charts are widely used because they are simple to understand and communicate the key information quickly.   

In this segment, you'll learn how to plot charts in Excel.  

It is important to understand that data visualisations can be used in two ways- 1) to explore insights in the data and 2) to present insights to other people. A typical presentation contains the latter type. While analysing data, you can (and should) use charts to understand patterns and trends. In fact, conditional formatting is also a type of data visualisation and is usually used to explore data.  

In the next segment, you will learn to plot a few more types of charts.