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. 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. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.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. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function.
MAKE A SUBSCRIPT IN EXCEL FOR MAC AXIS HOW TO
How to edit x axis Instant Connection to an Excel Expert
Microsoft Word is a text processor while Excel is a spreadsheet software, which mostly deals with data and numbers. How to change the scale How to Switch X and Y AxisĪnother interesting chart feature that we will learn is how to switch x and y axis. Applying superscript and subscript format in Excel isn’t straightforward unlike in Microsoft Word.
MAKE A SUBSCRIPT IN EXCEL FOR MAC AXIS SERIES
Select Data on the chart to change axis values Master the essential tasks in the Mac version of Excel for Office 365.
Let’s now see how to create a scatter chart, which will further make it clear what an axis is in an Excel chart. Axis has values (or labels) that are populated from the chart data. This step by step tutorial will assist all levels of Excel users in learning how to change axis values. The X-axis is the horizontal axis, and the Y-axis is the vertical axis. In Select Data chart option we can change axis values or switch x and y axis If we want to edit axis or change the scaling in the graph we should go to Format Axis options.