![]() Settings are grouped in 4 areas: Axis options, Tick marks, Labels, and Number.įor a value axis, you'll find upper and lower bounds, major and minor units, the axis crossing point, a menu displaying units for large numbers, a checkbox for logarithmic scales, and a checkbox for plotting values in reverse order. Make sure you're on the axis options icon. To start off, right-click and select Format axis. Let's walk through some of the options for customizing the vertical value axis. When I create a line chart, the vertical axis is a value axis showing the mortgage rate, and the horizontal axis is a category axis, grouping the data in specific date intervals. Here we have historical data showing average 30 year mortgage rates over a 5 year period. In this video, we'll look at options for customizing a value axis in an Excel chart.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |