“So first of all select everything and insert a chart then to make a secondary secondary axis is nice and easy just double click on one of the lines to up the formatting bar and change it to the secondary axes. Then to make a third axis is more complicated. But we are going to make two charts. So press.
Ctrl d. To duplicate the chart then on the second chart. Delete. The blue and the orange lines then on the first chart.
Delete the grey line and on the second chart change the fill to no fill and we are going to line..
These two charts up over the top of each other to make it look like we have an excel chart with three axes. There s quite a lot of formatting. We need to do before them go to view and remove gridlines then remove the border from both of the charts. Then on the second chart remove the gridlines.
We can t delete the chart title. Because if we do the size of the chart will expand and we want this to stay the same size as the other chart. So instead go to text. Options and change.
The text fill to no fill virna..
The next thing to do is to add axis titles to all of this to make it clear. Which axis goes with which data set so i will make it equal to this column heading here and then change the color to match the lines make the font blue and bold and bigger and also change the font here then on the axes change the line to be blue and to make it thicker and i will do that to the other two axes as well making sure to change the color. You okay and now if i line the two charts up over the top of each other we get something closer to what we actually want but at the moment. The gray and orange axes are overlapping so in order to fix this we will change the maximum and minimum on this x axis.
We will decrease the minimum a little bit and this will cause the gray line to be shifted to the right and create a gap between the gray line and the gray axes. Which is where the orange axis is going to go so i will change the eight to a five then i need to change the maximum back to what it was before in order to match the other charm. Then i don t want this x axis to have labels on it. But i can t just delete them because that will change the size of the chart.
So go to text options and change..
The text fill to no fill then for the time being i will change the axes line to be a nice bright color and to be really thick to make it easier to line up the charts. So line up the end of the pink line with the beginning of the blue line. Then hold down control to select both charts and go to shape format and align and align. Middle to make sure both the charts are perfectly lined up horizontally.
Then expand the chart with the gray axes on it until the gray dots line up with the blue and the orange dots. So we ll just move it to the left a little okay and now that that is lined up. We no longer need this pink line down. Here so change it to no line and also take the legend here and move it to the side now we will change the axes maximum and minimum values.
So that all the lines aren t squashed together so for the orange line..
I will change the minimum to be 60 and the maximum to be 120. Then for the gray axes. I ll change the minimum to 5. And the maximum to 30 and now the lines are more spread out now if you want this chart to have a border go to insert and insert a rectangle and to draw it over the top of the two charts then send it to the back and change the shape outline to black and the shape fill to white.
Then select one of the charts and press ctrl a to select all go to shape format and group. Everything. And now we have everything grouped together so we can move it around as if it were one object okay so in this video. I have made what looks like a excel chart with three axes by creating two charts and lining them up over the top of each other okay and that is everything ” .
Thank you for watching all the articles on the topic How to make a chart with 3 axis in excel . All shares of thetruthaboutdow.org are very good. We hope you are satisfied with the article. For any questions, please leave a comment below. Hopefully you guys support our website even more.
“Create two charts and line them up over the top of each othern———————————————————————————n#exceltutorials #exceltips #excelchartsnnSUBSCRIBE: https://goo.gl/c46YPsnnMicrosoft Office 365, 2016, Office Insider, Version 1910nnThese data are related to my PhD researchn———————————————————————————nIF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:n- How to make multiple charts using vba in excel https://youtu.be/5_p8hltGY4sn- How to quickly make multiple charts in excel https://youtu.be/3u4TU1PbhAkn- How to make panel charts in excel – method 1 https://youtu.be/DAUh2Xvxt3w”,
3 axis chart, 3 axis chart in excel, 3 y axis chart, third axis in excel, third axis in excel chart, three axis chart, graph with 3 y axis, three axis in exc…