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.
To provide more variety and visual impact, you can use the many shape outline and shape effects such as glow, 3D, soft edges, reflection. These are options on the Format tab that you can apply to various chart elements. When the Format tab is active, as it is right now, if you were to go to Shape Effects, suppose I want to make a Shape Effect application to the title here. I am going to click here and try one of these, and I want to point this out because I remember doing this a while ago, trying to apply something called Glow and I'm trying this and here are some choices and nothing seems to be happening.
The reason it's not is that most of these features here that we are talking about, Shape Effects, Shape Outline, are dependent upon the idea that you've already applied a shape style. So, let's click the drop arrow here and maybe just pick one of these at random, say this one right here. Now, if we go to Shape Effects, we could apply a glow here and Glow is one of these features where I think a lot of us thought, "Have we really needed this? Has this been missing from our lives?" Well, we've got lots of choices here, and you see what's happening as I'm sliding over these various choices here. You see what it's doing to the title. And used with discretion, and not in every single example, or in every single body of text, this might make some sense.
Again, we are talking about a little bit of pizzazz here, a little bit of flare that you want to provide on this chart or that chart, something like that. Clicking outside of this, by the way, we are not seeing the border. So, the Shape Outline maybe has something to be said for it too, so that button, Shape Outline, also in the same general area on the Format tab, right above Shape Effects. We can change the color of the outline. For example, right now, we can see that the box around the Two Trees Olive Oil Company is sort of orange. You could, then from there, if you wanted to, probably some of those other choices here, change the thickness of this.
Now, without suggesting that these are all frivolous, again, you can get a little carried away with this. It's going to take up some time as you try some of these various choices. Keep in mind, some of these might be applied to the inner plot area or the outer chart area as well. The example here, as I suggested earlier, choose a Shape Style first and then come in if you want to explore some of these choices here. Shadow probably wouldn't have much impact here, and as you make the choices and slide over these, you can see to the left of where I am pointing right now, look at the perimeter of the plot area. Right now there is a shadow on all four edges.
If you want a shadow just in the upper left, we will come down here, and you'll see how the image shows the shadow above and to the left, but not below into the right, and so on. And then there are inner shadows as well. You can see all of these choices. Things that maybe we didn't know we needed or wanted, but they are here. Depending upon what it is you've chosen, not every possible choice is available here. If I wanted to explore Reflection a little bit, maybe I go over here on this chart and choose the title. Again, Reflection is not available to us, so possibly we will make another change, give it a color maybe. And what happens now? Do we have--no, still no Reflection available.
So you will be surprised here and there as to when certain choices appear and don't appear, and some of these are available with different parts of a chart. Shape Effects, Shape Outline effects, all designed to make the chart more appealing from your perspective.
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.