#EXCEL 2016 MAC MOVE VERTICAL AXIS HOW TO#

For major type, let's say that I click and I say inside and there you can see that I have tick marks that just appeared in the chart area. So if I click that option here and scroll down, then I can have major type, minor type. In this case, I'll just set it back to none. So if I were to select thousands, then I would see five, 10, 15 and 20. It's currently set to none, however, I have options for hundreds and thousands, that sort of thing. The horizontal axis crosses are the same attributes I explained before. And now you see that I have values of 5,000, 10,000 15 and 20. Let's say that instead of having major units be 2,000 I'll change it to 5,000 and press enter. In this case, that would be too small of a ratio so I don't really worry about it. I also have major units which are set at 2,000 and those are the 2,000, 4,000, 6,000 and so on labels. The bounds which is the minimum number, in this case is zero, which seems reasonable and the maximum is 18,000. Doing so displays the format axis task pane, but you can see that I have different options. Now, I'll close the format axis task pane here and I will double click the vertical or y axis.

If I wanted to change the attributes of the text, for example by making it bold, then I could select either the entire axis or just one of the values and then use the controls on the home tab of the ribbon to format the text. So if I click that, you'll see that I can change the text fill, which would basically change its color and also the text to outline. Obviously, I have text options available. So if I wanted to reverse alphabetical order, I could check that box and it would go solar panels down to batteries and you also notice that the axes labels removed to the right side. The final option would be to display the categories in reverse order. I can also have the axis position, either between tick marks or on tick marks. Or I can have it cross at a category number, for example, the lowest value for solar panels which would be considered zero, or at the largest category. In this case, it's automatic and it happens at a zero, which you can see here, that's what the dash there means. You can also select where the vertical axis crosses the horizontal axis. I could, however, set it for text, which is what my values are, the category names. The first is to set the axis type based on the type of data and that usually works well automatically. There are a number of options that I can use here. And doing so displays the format axis dialogue box and you can see that I have access options below. So, for example, to work with the X-axis, I will double click batteries. If you want to format either of the axes, double click any value on that axis. And those are batteries, landscape, lighting and light bulbs, and solar panels. And the x axis, or horizontal axis, has the category data. The vertical axis displays the numbers, and those are the order counts for each of the years and each of the categories. The chart I'm working with here displays orders by category in year, and it's based on the data in the worksheet, some of which is obscured by the chart, but you can see that we have four different categories, and also values for 2016, 2017, and 2018. My sample file is the chart axes workbook, and you can find it in the chapter seven folder of the exercise files collection.

#EXCEL 2016 MAC MOVE VERTICAL AXIS HOW TO#

I'll demonstrate how to make those changes in this movie.

As with other elements of your charts, you can control the appearance of those markers. When you summarize data in a chart, Excel adds markers and labels to the chart's horizontal and vertical axes to help viewers interpret the chart's contents.

Excel 2016 mac move vertical axis