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.
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!
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!