Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Hopefully, you're very impressed with the ease that Excel 2007 offers you to create charts. What we're going to take a look at is the final piece of creating charts, and that's talking about the formatting of the chart and some other options that you can turn on and off, to enhance their look of your charting. Open up EatCake SalesB and select the chart by clicking on it. That opens up your Chart Tools tab, and this time we are going to look at the Layout tab that we have to choose from. And here, you get to adjust further, the information that you are presenting on your chart.
Under Current Selection, you can adjust the Current Selection to work not only your chart area, but other areas in your charting. You could go right down to your different series and change up those. You can work with the Labels and you can change up your Labels by changing your Chart Title. You can determine where that chart title is going to be presented. Do you not want to have one? DO you want it to be centered and overlaid without resizing the chart, or do you want it to be presented above the Chart as we have here.
You can adjust your Axis title. Sometimes it's important to identify the information that you have and explain what you're looking at. And you can add, remove, or position the text used to label each of the Axis. You can look at your Horizontal Axis, or your Vertical. In this case, I think it's quite important to have the information presented on my Axis, so I know who I'm talking about in terms of my salesperson as well as what revenue figures they were bringing in that particular quarter.
Sometimes it's important to put my legend in, and sometimes it's not. Because I'm color coding my legend in this case, it is. So I want to leave it in, but I may want to move it around on the chart. I may want to adjust my Data Labels. So if I turn off my Data Label, then I would not have anything showing. I could center my Data Labels and points on the chart itself. And there I'm showing all of the values per quarter that each individual salesperson came in. Now obviously this does not enhance the look or readability of my chart at all, so I'm going to turn it off. But in some cases, sometimes it's important to show that information. But visually, this is a very striking chart because I can see exactly the information that I need to present very easily, just the way that it is.
Over here on my Gridlines, I can choose--or my Axis--I can choose to show either the Gridlines. So I can turn them off, So here you see that it removes the Gridlines, it just shows me visually who's the highest. It doesn't help me identify who the top performer for WADE is. You'll notice as I'm mousing over the different series, it also puts in the information about what builds that particular value.
Why did I get that particular pink line as large as it is and it shows that for this WADE for Q4, he brought in just under $8, 000 worth of revenue to the organization. It might be easier for me to show the Gridlines, so I'm going to put on the major Gridlines here. And it helps me visually identify where his values are and how much he's done accumatively, in terms of revenue within the organization.
SO you can see here that you have lots of other options on how to help identify the key points in your charting and it's very easily done in Excel 2007 by clicks of the button and your Chart Tool options.
Get unlimited access to all courses for just $25/month.Become a member
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.
Your file was successfully uploaded.