Using two axes in one chart
![Chart with several axis in Excel for Microsoft 365 Chart with several axis in Excel 365](/images/tips/208_365/1.png)
![Chart with several axis in Excel for Microsoft 365 Chart with several axis in Excel 365](/images/tips/208_365/2.png)
For example, if you have two too different data (e.g., sales Volume and Price), which you want to see in one chart:
![Data range in Excel for Microsoft 365 Data range in Excel 365](/images/tips/208_365/3.png)
To create one chart for these data, do the following:
1. Create the chart with that data range:
For example, on the Insert tab, in the Charts group, click the Insert Bar or Column Chart button:
![Insert Bar or Column Chart in Excel for Microsoft 365 Insert Bar or Column Chart in Excel 365](/images/tips/charts365/column_bar.png)
Choose Clustered Column:
![Clustered Column chart in Excel 365 Clustered Column chart in Excel 365](/images/tips/charts365/clustered_column.png)
You can see not informative chart because of too different data scales:
![Simple column chart in Excel for Microsoft 365 Simple column chart in Excel 365](/images/tips/208_365/4.png)
2. Right-click on any data series and select Change Series Chart Type... in the popup menu:
![Change Series Chart Type in popup menu Excel for Microsoft 365 Change Series Chart Type in popup menu Excel 365](/images/tips/charts365/change_series_chart_type.png)
3. In the Change Chart Type dialog box, in the Combo group of charts, choose the secondary axis for the second data series:
![Secondary Axis in Excel for Microsoft 365 Secondary Axis in Excel 365](/images/tips/208_365/5.png)
Note: In this dialog box, you can change the chart type for each data series.
Change other parameters for the secondary axis.
To add the next data series with another axis, see Combining several charts into one chart.
See also this tip in French: Comment utiliser deux axes dans un graphique.