The top axis options can be adjusted for example you could change the scale to start and end or change the unit settings so there’s not so many labels. So these are two simple and easy ways to switch the axis in Excel charts. Under ‘Axis Type’ you can force Excel to consider the data text or date but if Excel has guessed wrong then there’s usually a problem with the source data. Select the chart type you want, and select OK. Windows macOS Create a chart from a table Select the cells you want to use. Also, this way you don’t need to change any data in your sheet. If you need to change data in a chart, you can do it from its source. Click OK to close the dialog, then the original data and the data table numbers in the chart are changed at the same time. Switching the axis option in a chart gives you more flexibility for adjusting the chart axis. In the Format Cells dialog, click Number > Number, and then in the right section, specify 2 in the Decimal places text box, and check Use 1000 separator option.
In this case, you can just move Quantity in column B, and Sales in column C. A complete video tutorial on How to Make or Plot a Graph or Chart in Excel 2013. 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.