Budget Limit Line w/ Stacked Bar chart?
I have a chart like the above right now and have some questions:
Is the best way to implement a Budget Limit line through a Beast Mode like this? I was initially thinking of using the 'Goal' function in the Y-Axis but I don't want it to say 'Goal' since this isn't a goal but rather a way for people to see if they're over or under budget.
Second, without the Budget Line, the AMOUNT column is separated out into their appropriate Categories series, but with the Budget Line, that isn't happening. Is the only solution to this to create a different Beast Mode for every single Category? This would be extremely tedious and wondering if there's a better solution.