Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you want to control the appearance of axes lines or gridlines, you can do this in a number of different ways. And in some sense, this illustrates the fact that I think a lot of us, myself included, become a little bewildered at times as what's the best way to do things, because they're so many different ways to approach this. In the chart on the left are some gridlines, and maybe we want to make some changes. Now a lot of you know that in creating gridlines many times where you would start would be to go to the Layout tab and choose Gridlines, possibly apply them this way. And along the way in that process you might come to More Primary Horizontal Gridline Options, makes some choices.
We can control Line Color and Line Style, so there is certainly that approach. When you created the chart you could have gone to the Design tab, chosen Chart Layouts, and some of the options here have gridlines, some don't. You could've start the gridline process that way. How about format? We could go to Format, and if you have selected a gridline as I have here, we've got some Shape Styles related to gridlines. And if that weren't enough, if some how you said I need to change these, or do something to these gridlines in terms of their appearance, we could right-click on a gridline and go to Format Gridlines, leading us to a dialog box we just saw.
There are so many different ways to get into this process. So let's just take the example here where we have gridlines already, possibly. Click this one. We've got some shape styles, and of course you knew there are going to be more then seven. We've got 21 of them, and I would suggest the heavy ones don't look good at all. These overwhelm the data substantially. Even these are a bit much. So I would say use these sparingly, but again, for some situations maybe these are appropriate. You can certainly make those choices that way. If we were to right-click on these, we can go to Format Gridlines and make some choice here. Maybe the line style will look better if we a dash type here, and again these are similar to features you might have seen previously, coming at them from different angle perhaps. And after making those choices, maybe we'll say let's change the Vertical Axis on the left-hand side, make it more dramatic perhaps.
We've got Axis Options. How about Line Color? Solid line maybe, different color, make it red maybe. How about Thickness? Line Style, again features we might've seen previously. We've got complete control over all these, but the entry to these can come from a variety of different points, through the Design tab at the time you are creating these lines, through the Layout tab possibly to adjust gridlines, through the Format tab or simply by right-clicking. Lots of different ways to achieve line color style and weight changes.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 90593 Viewers
80 Video lessons · 137947 Viewers
59 Video lessons · 56700 Viewers
52 Video lessons · 70313 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.