While I have shown an example of a scatter chart in this tutorial, you can use the same steps to switch axis in case of any chart in Excel. So these are two simple and easy ways to switch the axis in Excel charts. You can used it when the range of values in the chart varies widely or you have mixed types of data. Microsoft Excel Combo Chart is used to highlight the different types of information.
Also, this way you don’t need to change any data in your sheet. We are ready to generate Multiple Line Charts On Excel Secondary Axis Combo Graph. Switching the axis option in a chart gives you more flexibility for adjusting the chart axis.
In this case, you can just move Quantity in column B, and Sales in column C. The above method works great when you have already created the chart and you want to swap the axis.īut if you haven’t created the chart already, one way could be to rearrange the data so that Excel picks up the data and plots it on the X and Y axis as per your needs.Įxcel by default sets the first column of the data source on the X-axis, and the second column on the Y-axis.
