How to make a chart with 3 axis in excel

Adjust the numbers so the lines are closer together. Then make fake data sets and format them so they look like an axis.
---------------------------------------------------------------------------------
#exceltips #exceltutorials #excelcharts
SUBSCRIBE: goo.gl/c46YPs
Microsoft Office 365, 2016, Office Insider, Version 1910
These data are related to my PhD research
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to make a chart with 3 axis in excel • How to make a chart wi...
- How to make a panel chart in excel - method 2 • How to make a panel ch...
- How to quickly make multiple charts in excel • How to quickly make mu...

[@sw9887]

Lovely from 2023. Thank you.

[@nasroml12]

Great video with nice tips as usual, thx a lot Karina

[@tara4982]

Thank you for making the video, very helpful. just a question. Can we make up to 5 y axis with the same method? thank you

[@alndr4u]

Can this chart be used with pivot table ?

[@nicolaslarisaleclerc956]

Hello, when i add my third y axis, it changes the x values of my others series .... do you have an idea why ?When i add a serie, i can only select Y values and not also X values, so it takes the whole charts X values ..... i don't know why

[@happyyadav4659]

Hi its easy to do with dates on x axis can you do with some numbers figure starting from 0 i am not able to do it as I have data starting from zero to 50

[@karinaadcock]

Make the 3rd axis have negative numbers for the x values. Select the x-axis go to axis options and change vertical axis crosses to Axis value and set it to be whatever number you want.

[@MalikMalik-kf1md]

It looks like doing math