Click Change Chart Type in the Type group.

Click the DESIGN tab under the CHART TOOLS tab on the Ribbon.

Use Vertical Columns for the target values and a Line with Markers for the actual values. In Excel 2013 and versions above, you can use Combo charts for the same purpose.

It does not give a true impact on your results.Ī better way of distinguishing two types of data to compare the values is by using Combination Charts. 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 excel template