When we create a bar chart with 2 data elements, we will usually show the bars side by side. But there is a better way of showing this data especially if we want to compare target v/s results. We can use the overlay or overlapped bar chart in this case in Microsoft Excel.
Let’s see how this is achieved. There is no overlapped bar chart by default which we can use, so we need to make some modifications to a bar chart to accomplish this.
We have monthly data showing the targets and sales achieved, we need to first plot a 2D clustered column chart. To do it follow the below mentioned steps:-
The 2 bars on the chart now completely overlap each other. A few more steps to go and we are done. Do the required formatting like removing gridlines and adding in axes labels.
To give the bars the overlap kind of look follow the below mentioned steps:-
Conclusion:- Now you can see in the above picture how you can use this chart to compare the target V/S achievement. It is showing the over-achievement and under-achievement very clearly.
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.