Hello all!
I am trying to insert a bar chart into excel that I have seen elsewhere, but I cannot figure out how to get the look. Attached is a pic of what I am looking for.
All I want to do is to compare two numbers, the budget total and the total spent so far.
Can anyone tell me how I can get a bar chart like the one in the attached pic?
Thanks so much!!
Hi,
Does the attached help
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Create a stacked bar chart. Switch row/columns so Budget and Spend are the series.
Select Spend series and move to secondary axis
Delete secondary axis
Change fill and border formats of Budget series
Add data labels to Spend series position Inside End
Thanks very much, this is exactly what I was looking for!
Hi Richard, thanks for your reply.. this is not really what I meant.. but Andy's sheet is what I was looking for. Thanks for replying though.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks