Bar graph

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
Steve BezAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Edward PamiasTeam Lead RRS DeskCommented:
Change the Axis to Primary. See if that helps.
EE--Copy-of-Book2.xlsx
Steve BezAuthor 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 DeskCommented:
Check this one out... I am getting there.... but no matter what the other bars move.
EE2--Copy-of-Book2.xlsx
Ensure Business Longevity with As-A-Service

Using the as-a-service approach for your business model allows you to grow your revenue stream with new practice areas, without forcing you to part ways with existing clients just because they don’t fit the mold of your new service offerings.

Download eBook
Steve BezAuthor Commented:
I'll check and let you know. Thanks
Steve BezAuthor 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.
Ejgil HedegaardCommented:
Check this
Book2.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Steve BezAuthor 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!
Steve BezAuthor Commented:
amazing!
Steve BezAuthor Commented:
Edward, thanks a lot for your help as well!
Edward PamiasTeam Lead RRS DeskCommented:
I tried... but I am still waiting for the real wizard to let us know what he did.
Ejgil HedegaardCommented:
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 DeskCommented:
You cheated! LOL!  Nice work!
Steve BezAuthor 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 DeskCommented:
Steve, I am just teasing him, He did a great job!
Steve BezAuthor Commented:
I agree. Thanks Edward!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.