Budget Analysts – How would you answer this Excel Chart question?

Two months back there was a posting in the Mr. Excel forums that I thought most budget analysts might be asked by there executive team, managers or co-workers.  I would like you to read the post and come up with your best solution.  Put your solutions in the blog comments.  Then I will show you what I proposed in posts next week as well as a video tutorial on how to build that solution.

HINT: Remember that sometimes the direct question from your managers/co-workers is not the best/right answer, so open up your minds on how you would create this chart if your manager asked you a similar question.

So that is your homework and below is the detailed questions:


Article Title: Bar Graph Below the Line

I created a stacked bar graph to show the amount we spent and how much we have left to spend (data below).

What I am looking to do is show the bar chart below the line, in a different color for those times we over spent.

How do I need to modify this table and data sources?

How can I have the “overage” bar automatically a different color?

How can I have this graph below the line without running over the text on the x axis?

Data Sample Provided:image

That is all you get.  Let me know what types of Excel Dashboard Chart Components you would suggest to this user.



Please enter your comment!
Please enter your name here