How-to Stop Excel Charts from Overlapping Second Axis Columns or Bars

It may seem like Excel is changing your Clustered Column Chart to a Stacked Column Chart or your Bar Chart to a Stacked Bar chart when you move a series to the Secondary Axis, but don't worry, it isn't. Learn how to separate your columns or bars in your Excel Chart when you move a series to the secondary axis.

If you want to know how to do this with a chart from a pivot table, check out this post:

[ehelvz]

Nearly EIGHT YEARS later and still have to use this ludicrously unintuitive workaround. THANK YOU for saving my sanity!

[AyosBoll]

This worked much better than cursing at the computer

[DuarteMolha]

ridiculous you have to still be doing these stupid hacks in excel to get something so obvious as to display 2 datasets in 2 axis without overlaps.

[jenniferdiment]

Thank you for making a straight forward video! It is surprisingly hard to find simple videos like this sometimes

[julietlondon]

I have looked for this so many times - your explanation is by far the easiest explanation for this problem that I seem to face all the time. Thank you thank you.

[spam]

This is awesome. I was going nuts trying to do this for a week! My boss will be so happy. If you want to eliminate the confusion as to which data goes with which column, you can supply individual axis labels for each axis which clears that right up. Thank you so much.

[dimplemodugula]

I have been through a ton of videos today and landed here. Thanks for helping mate

[akniv]

You're a genius! Thank you, you saved me a lot of time. It's 2017 and I can't believe this process still has to be so involved. Please don't ever delete this video :D

[kailiwang]

after all these years, I have learnt to seek youtube for help whenever I encounter stupid excel problems.... and it always works... thanks to all these nice people who put out tutorials...

[clarkchong]

Thank you so much! Best tip ever! Most of the places online only teach one to change the chart type which is not what I needed...

[roykudo]

This video saved me from the very bad day in 2022 which I kept finding the solution about this problem.
Thank you very much!

[AKennethNolan]

Thank you so much. The way Excel does this INFURIATES me. I've been trying to figure this out on my own forever with no luck. Never thought to add "pad" columns!

[shahilh]

My guy you are a life saver. Thankyou for this video

[alibarthram]

Thanks so much for the video! It was driving me insane trying to sort this out for my uni assignment

[Prime-Gaming]

I can't explain how much stress you've just saved me from! Thanks!!

[Bumzest]

I have been looking for how to fix this issue for months!
THANK YOU for showing this and explaining in such a simple way!!!

[yff]

Took me 1 hour to find this video.. exactly what I wanted!

[Rosskozak]

Thank you for making a clear video for this solution. Also for anyone else who has extra columns such as for a YoY view of data, you only need to add another set of padding columns. Just repeat the process with the extra set and it should all line up.

[rmclean]

This is absolutely genius! Was driving myself crazy trying to figure out how to do this. Thank you!!!

[fredneurohr]

Thank you very much for this workaround. I can't believe an easy function in Excel -- and PowerPoint for that matter -- has disappeared. You deserve credit for creating an easy solution for a problem that, by all accounts, should not exist.