Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a bit of a newbie question. I am trying to create a Combo chart or a Line chart with monthly sales, together with a budget line that will run over the chart as a comparison line to see if we reach our budget.
I have created the chart with our monthly sales per year, but how do I implement a line with a fixed budget sum that should be the same for every month, running over the entire year?
I have tried to add a new expression in a Combo chart that will represent the fixed budget sum, but I am not sure which definition the expression is supposed to have. To make things easier while helping me, lets say that the fixed sum I would like to implement has the value of 10000.
I am thankful for all the help i can get.
On the Presentation tab, you can add a Reference Line.
Hi
As long as the sum is fixed for each month, then, for value 10000, just enter 10000 in the definition for your budget expression.
Thank you for the help. That´s a very easy solution that will do the trick.