We will create a Clustered Column Chart for these results.Īs you observe, it is difficult to visualize the comparison quickly between the targets and actual in this chart. Suppose you have the target and actual profits for the fiscal year 2015-2016 that you obtained from different regions. In this chapter, you will understand the different techniques that you can use with the Excel charts to highlight your data analysis results more effectively.

Refer to the Tutorial Excel Charts for more information on chart types. Excel provides you with many chart types and you can choose one that suits your data or you can use the Excel Recommended Charts option to view charts customized to your data and select one of those. A chart is a visual representation of the data, in which the data is represented by symbols such as bars in a Bar Chart or lines in a Line Chart. In Excel, charts are used to make a graphical representation of any set of data. In this chapter, you will get to know how to use Excel charts and Excel formatting features on charts that enable you to present your data analysis results with emphasis.

It also leaves a good impact on your presentation style. However, if your data analysis results can be visualized as charts that highlight the notable points in the data, your audience can quickly grasp what you want to project in the data.

You can display your data analysis reports in a number of ways in Excel.

Data analysis plus excel 2016 for mac