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.

Learn Excel Dashboard Course

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?

Learn Excel Dashboard Course

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.

Steve=True

Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy




Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy

LEAVE A REPLY

Please enter your comment!
Please enter your name here