Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In this course, Dennis Taylor shows how to analyze and communicate the value of data with charts in Excel. The course starts with the foundations: what the parts of a chart are, what the different types of charts are, and which charts work best for your data. The course then shows how to create a presentation-ready chart in minutes and offers dozens of in-depth tutorials on formatting and fine-tuning charts so they represent data clearly and accurately.
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.
There are currently no FAQs about Excel 2007: Charts in Depth.
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.