Avatar of Steve Bez
Steve Bez
 asked on

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
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Steve Bez

8/22/2022 - Mon
Edward Pamias

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

ASKER
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 Pamias

Check this one out... I am getting there.... but no matter what the other bars move.
EE2--Copy-of-Book2.xlsx
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Steve Bez

ASKER
I'll check and let you know. Thanks
Steve Bez

ASKER
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.
ASKER CERTIFIED SOLUTION
Ejgil Hedegaard

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Steve Bez

ASKER
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!
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Steve Bez

ASKER
amazing!
Steve Bez

ASKER
Edward, thanks a lot for your help as well!
Edward Pamias

I tried... but I am still waiting for the real wizard to let us know what he did.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Ejgil Hedegaard

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 Pamias

You cheated! LOL!  Nice work!
Steve Bez

ASKER
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!
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Edward Pamias

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

ASKER
I agree. Thanks Edward!