The most common analysis done across industries with the target vs actual. One of my client has a column chart where it displays the product-wise target vs actual, In which they can analysis which product is lagging and leading.
I have proceed with Stacked Column chart, for the same analysis, with more efficient way of understanding the lagging plant crisply.
Earlier the chart was displayed in the below format. Still i feel its not more effective.
Note: In this scenario the list of products are static and not varying based upon the prompts.
List of Components used.
2.Stacked Column chart
The data which is highlighted in yellow, are the actual & target data from the source.
Assigned counter values for the play selector and inserted in the red cell.
The difference between the actual & target is done in the row “E”. [=F4-D4]
Finally the target is calculated using the “MOD” function in the row “C”. “=IF(E4<0,0,(IF(MOD(G3,2)=1,0,E4)))”. Apply the logic in subsequent cells.
Make sure you send the play selector behind the chart “Send to back”. Now go to the preview mode you can see the target vs actual difference is blinking.
Note : I have tried this scenario, with limited No.of Data, so that my excel formula didn’t hampered my performance of the dashboard.
We can use this technique for lot more option like highlighting some text in the dashboards. Can be used for alerts & warning too.