![]() ![]() 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. Timeline / Milestone - Excel Line Chart Changing Horizontal Axis Values. So these are two simple and easy ways to switch the axis in Excel charts. This inserts a line chart with X-Axis values as 1,2,3. Also, this way you don’t need to change any data in your sheet. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |