![]() Right-click and select Format Data Series.In the chart that is inserted in the worksheet, Click on any of the bars for Actual Value.In the Charts Group, click on the ‘Clustered Column Chart’ icon.Select the data for target and actual values.Here are the steps to create this Actual vs Target chart: It is better to have the Actual Values in dark shade as it instantly draws attention. This chart (as shown below) uses a contrast in the Actual and Target bars to show the whether the target has been met or not. #1 Actual vs Target Chart in Excel – Target Values as Bars In this tutorial, I will show you how to create these two actual vs target charts. In the chart on the right, the actual values are shown as the blue bars and the target values are shown as red markers. In the chart on the left, the target values are shown as the wide gray bar and achieved/actual values are shown as the narrow blue bar. Here are the two representations that I prefer: ![]() There can be multiple ways to create a chart in Excel that shows the data with Actual Value and the Target Value. If you work involves reporting the actual and target data, you may find it useful to present the actual values versus the target values in a chart in Excel.įor example, you can show the actual sales values versus the target sales values, or the satisfaction rating achieved versus the target rating.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |