Excel for Microsoft 365 Excel 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Excel 2007 Word 2007 Outlook 2007 PowerPoint 2007 Excel 2016 for Mac PowerPoint 2016 for Mac Word 2016 for Mac Word for Mac 2011 Excel for Mac 2011 PowerPoint for Mac 2011 Excel Starter 2010By default, Microsoft Office Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you can customize the scale to better meet your needs. When the values that are plotted in the chart cover a very large range, you can also change the value axis to a logarithmic scale, also known as log scale.To change the scale of other axes in a chart, see.To change the number at which the vertical (value) axis starts or ends, for the Minimum or Maximum option, type a different number in the Minimum box or the Maximum box. You can click Reset to bring it back to its original value if needed.To change the interval of tick marks and chart gridlines, for the Major unit or Minor unit option, type a different number in the Major unit box or Minor unit box. You can click Reset to bring it back to its original value if needed.To reverse the order of the values, select the Values in reverse order check box.Note When you change the order of the values on the vertical (value) axis from bottom to top, the category labels on the horizontal (category) axis flip from the bottom to the top of the chart.
![]() ![]() ![]()
Every Mac user needs a handful of Excel chart tricks to impress their friends. Changing the transparency setting moves the picture nearer to the background of the chart. In the Format Trendline dialog box, choose a line color and line style. For example, here we have historical stock data for Microsoft covering more than 15 years in more than 100 rows of data. If I insert a line chart, Excel automatically builds a condensed horizontal axis and plots all the data. And I can easily use the Chart Filters menu to exclude everything but the close price.
Note: The screen shots in this article were taken in Excel 2016.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |