How do you make a 3 axis graph in Excel?
3 Axis Graph Excel Method: Add a Third Y-Axis
- Create a 3 Axis Graph in Excel.
- Decide on a Position for the Third Y-Axis.
- Select the Data for the 3 Axis Graph in Excel.
- Create Three Arrays for the 3–Axis Chart.
- Add data labels – select data label range.
- Add a Text Box for the Third Axis Title.
- Updating the Chart.
How do I graph 3 sets of data in Excel?
To create a combo chart, select the data you want displayed, then click the dialog launcher in the corner of the Charts group on the Insert tab to open the Insert Chart dialog box. Select combo from the All Charts tab. Select the chart type you want for each data series from the dropdown options.
Can you have a third axis in Excel?
The third axis is actually a fake axis in the context of plotting data. In other words, while it will allow you to read an associated data series as if it was plotted against it, you are actually plotting a scaled version of your third axis data set against one of the other two axes provided by Excel.
