Forum Discussion
Budgeted vs Actual Chart
Community ChampionLuciano You can use stacked column or bar chart which will be the closest to what you've got in excel. but you can also use other visuals. all you need to do for stacked column or bar chart is to drop actual and budget fields under Values section.
ankitpatira The problem is that this way the bars are added. Ideally, they overlap, so that is possible to analyze how much of the budgeted has been spent.
Hi Luciano,
You can create a column chart using your data, turn on Data labels as shown in the following screenshot, this way, Budgeted values and Actual values will stand side by side in the chart, which is easy for you to view.
If the above chart doesn’t satisfy your requirement, please describe more details about your expected result.Thanks,
Lydia Zhang
