If you try to plot Actual vs Target values in form of a Clustered Column in Excel, it will look like this:Įven though, it will get the job done it will be slow to read and difficult to interpret by the users.
In this article, you will learn How to Overlay Charts in Excel and easily compare two sets of data in one graph, like actual sales vs target sales results, actual rating vs target rating, etc.
