I am trying to do a budget graph. I need to include one bar for the total budget spent and the next bar should be a combination of the expenditures and remaining balance. This will leave the two bars the same height as they will equal each others total. Does anyone know how i can set this type of bar chart up?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel Chart Help
- Thread starter pageau
- Start date
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
I don't think you need two bars. Plot the spent and unspent amounts as a stacked column chart.
Upvote
0
Andrew Poulsom
MrExcel MVP
- Joined
- Jul 21, 2002
- Messages
- 73,092
Plot the total as a Line chart. Add Data Labels above then format the series as Line and Marker None.
Upvote
0
tusharm
MrExcel MVP
- Joined
- May 28, 2002
- Messages
- 11,029
An alternative to Andrew's suggestion about the Line Chart...
If this includes only one data point, see the Excel | Tutorial | 'Data Labels' page of my web site.
Or, put the total(s) in some cell(s) in the worksheet. Then, use Rob Bovey's free and mislabeled add-in XY Chartlabeler (www.appspro.com) to use the total cell(s) as the data label(s) for the topmost column on the chart.
If this includes only one data point, see the Excel | Tutorial | 'Data Labels' page of my web site.
Or, put the total(s) in some cell(s) in the worksheet. Then, use Rob Bovey's free and mislabeled add-in XY Chartlabeler (www.appspro.com) to use the total cell(s) as the data label(s) for the topmost column on the chart.
pageau said:
Upvote
0
Similar threads
