Bar graph

Steve Bez
Steve Bez used Ask the Experts™
on
Would someone be able to isolate the red bar on the graph so it will be next to the yellow bar on the right side?

Very urgent!

Thanks!!!
Book2.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Edward PamiasTeam Lead RRS Desk
Top Expert 2016

Commented:
Change the Axis to Primary. See if that helps.
EE--Copy-of-Book2.xlsx

Author

Commented:
Thanks Edward!

Unfortunately it changed the other bars and I need them to stay the same. Let me know if you figure out how to do it.
Edward PamiasTeam Lead RRS Desk
Top Expert 2016

Commented:
Check this one out... I am getting there.... but no matter what the other bars move.
EE2--Copy-of-Book2.xlsx
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
I'll check and let you know. Thanks

Author

Commented:
Edward, you are a wizard. Nobody were able to get that far but still, the red bar is not where it should be and the other bars should stay in-sync, like they were before. Nothing should change, except the red bar's location. Let me know if you can solve the puzzle.

Author

Commented:
Hey Ejgil,

Man, I don't know what planet you are from but nobody could solve this problem except you. I give you A++++++++++++++++

Now, the challenge is if you could explain to me what you did step by step, cause I want to be able to recreate something like that, next time I need it.

Again, I really appreciate your work and your incredible knowledge in Excel area!

Author

Commented:
amazing!

Author

Commented:
Edward, thanks a lot for your help as well!
Edward PamiasTeam Lead RRS Desk
Top Expert 2016

Commented:
I tried... but I am still waiting for the real wizard to let us know what he did.
Webinar is the only series on secondary axis, so it will show in the middle.
I added 2 series Dummy1 and Dummy2 and placed them before Webinar on the chart to push it or the right.
Then adjusted space and overlap to make it look correct.
Finally deleted them from the legend display, and adjusted the size of the legend.
Edward PamiasTeam Lead RRS Desk
Top Expert 2016

Commented:
You cheated! LOL!  Nice work!

Author

Commented:
Guys, you both did a great job!

At the end, the result is what matters and I'm satisfied with that result. I didn't set specific conditions on how it should be achieved. Both of you are very smart people and I respect it!
Edward PamiasTeam Lead RRS Desk
Top Expert 2016

Commented:
Steve, I am just teasing him, He did a great job!

Author

Commented:
I agree. Thanks Edward!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial