In this tutorial, you will learn how to transform bars into a stunning variance chart. If you are using a variance chart template, you only need to provide the actual value and the target value. For example, you want to compare the sales of two companies for the last 12 months. Note: we recommend you using combo charts for financial purposes.
How to create the template? As first, add data for the bars. We are using grey bars to display the plan value. On the lollipop chart, we’ll show the actual value. With the help of green and red arrows, it’s easy to show the differences. The green arrows are pointing upward, and the red arrows are pointing downward on the final chart. That is all! The template provides dynamic updates. If you change single or multiple values, the chart will reflect.