I have a field (Budget) in which the data for all months is the same and another field (Actual) which has different data for different months. So is it possible to plot a bar graph which shows just one bar (instead of displaying one bar for each month) at the end for this field, Budget and to display Actual values for all months as shown in the attached picture?
Second question: Is it possible to have a single bar at the end in the same graph which sums up all actual values and subtracts that by the Budget and displays the subtracted value in the bar so that I get to see the total amount remaining in the budget, as shown in the picture?
Or is there a better way of displaying this info in a graph?
Thank you for your suggestion. I tried the second method and yes, even i agree that this is a good option. But, as there is no dimension in the graph, i will not be able to see the graph with respect to few months when i make selections in the month list box right? Is there a way where I can implement even this?