![how to format x axis in excel how to format x axis in excel](https://d295c5dn8dhwru.cloudfront.net/wp-content/uploads/2019/05/15160914/Figure-3.-Change-horizontal-axis-values.png)
- #How to format x axis in excel how to#
- #How to format x axis in excel for mac#
- #How to format x axis in excel series#
#How to format x axis in excel how to#
How to edit x axis Instant Connection to an Excel Expert Finally, we changed the axis with sales value data per stores and years:įigure 16.Change the values from the x-axis to the “Years” by selecting in the Axis label range cell range I2:J2 (explained in the tutorial above).Change the range to both years (20) by clicking on the down-right corner and expanding the selection to the right:.Click on the chart and drag values from the source table to the upper table by left mouse click:.In the following example, we want to change sales values to yearly sales values per store (upper table). The chart will have more logic if we track store values per years. Click on the button Switch Row/Column and press OKĪs a result, switches x and y axis and each store represent one series:.Right-click on the chart and choose Select Data.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. Format axis for Minimum insert 15,000, for Maximum 55,000Īs a result, the change in scaling looks like the below figure:įigure 10.Under Axis Options, we can choose minimum and maximum scale and scale units measure.Select the axis that we want to edit by left-clicking on the axis.If we want to change the axis scale we should: In our example, we will change the minimum scale to 15,000 and maximum scale to 55,000 on the vertical axis. To change the scale on the graph we should go to Format Axis options. How to change vertical axis values How to Change the Axis Range As a result, we changed the y axis values:įigure 9.
#How to format x axis in excel series#
![how to format x axis in excel how to format x axis in excel](https://cdn.extendoffice.com/images/stories/doc-excel/axis-below-zero/doc-axis-below-zero-007.png)
To learn how to change vertical axis values, we should follow almost similar steps as in the example above:įigure 6. How to change the x axis to Store values How to Change Vertical Axis Values As a result, we changed x axis values from Years to Storesįigure 5.Select the Edit button and in the Axis label range select the range in the Store column:.Select Data on the chart to change axis values
![how to format x axis in excel how to format x axis in excel](https://blog.hubspot.com/hs-fs/hubfs/format-y-axis.png)
#How to format x axis in excel for mac#
Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel for Microsoft 365 for Mac Word for Microsoft 365 for Mac PowerPoint for Microsoft 365 for Mac Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Excel 2021 for Mac Word 2021 for Mac PowerPoint 2021 for Mac Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Excel 2019 for Mac Word 2019 for Mac PowerPoint 2019 for Mac Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Excel 2016 for Mac Word 2016 for Mac PowerPoint 2016 for Mac Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 More.