How to make a chart with 3 axis in excel
ฝัง
- เผยแพร่เมื่อ 1 ต.ค. 2019
- 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... - วิทยาศาสตร์และเทคโนโลยี
Lovely from 2023. Thank you.
Great video with nice tips as usual, thx a lot Karina
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
Can this chart be used with pivot table ?
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
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
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.
It looks like doing math