I've created a report that lists projects, their budgets, amount already spent and amount remaining in the budget. What I'd like to do is have a small data bar chart in the last column that visually displays the amount of the budget spent for each client/project as a percentage.
I attached a picture of what I had in mind. At a glance my boss would be able to look down the page at a list of projects and see which ones were 50% spent, 90% spent or overspent. I'm just not sure how to customize a chart to do this. Plus a lot of my figures are calculated so perhaps I should create a seperate dataset for the chart? I thought of using a pie chart but I think the data bar chart is a better solution.
Any ideas or input please share! If anyone with report/chart experience has a suggestion of how to display the desired graphical data I'm all ears!
budget-data-bar.jpg
You'll need the "stacked bar". Not sure what you want to do with the overspent. I think you should have a green bar up to 100% and then a red bar attached to it with the overspent (10% for example). You might not need an separate dataset. You probably can do all the calculations in the report.
The data labels are probably the most tricky part because you want to display the total budget also. I need to experiment somewhat to give you the right answer. I can make an example for you but than I need to know what version of SQL server you are using. And could you upload the report (.rdl) here so I can use that as a starting point.