Hi all,
I am trying to do a simple chart with Budget vs forecast. I want to display them in two columns without the amount showing. That part is easy. I do want the variance amount to display above them. Something like this I suppose. (https://www.excelcampus.com/wp-content/uploads/2013/08/Variance-on-Column-Chart.png) but I only need the calculation.
I've tried stacked charts, but I can't only display one of the totals.
I've tried overlapping charts, but can't get it to display correctly.
I've tried markers, but they don't repeat for each category.
Any help is appreciated
Are you looking for something like this?
What I would like to see is only one value displayed, centered above the two columns. The value should be the variance between the two columns. So in your example it would display 1M or so.
Is that possible?
I can calculated one with a marker, but a marker does not recalculate for each series.
I did find a work around for now. In the X-axis of the chart, I changed the text source to report expression and added the variance amount. This ends up displaying the variance at the end of the name.
If anyone has a better idea, I would love to hear it.
Thanks.
I propose that you use a chart that shows the variance only. if you also want to show a chart or charts who show the budgets and actuals. Since these are (more or less) time series, I usually make the base values (the budget and actual) in a line chart with 2 lines (budget line, actual line) and below it a bar chart that shows the variances.