Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Microsoft Excel 2007 supports numerous types of charts to help you display information in a much more meaningful way, to your audience. Charts can convey much more than numbers alone, because Charts present data in a visual way that makes it easier to see the meaning behind the numbers. And with the new charting capabilities in Excel 2007, it's easier than ever to turn the data into meaningful information. Every chart starts with data.
In Excel 2007, you can select your worksheet, and choose a chart type that best suits your purpose and click. And if you want to choose a different type, you just click again. So you can see various options just by pointing at some in the dialog box. So you don't have to spend time applying and reapplying different chart formats and changes and making adjustments to your data. This is one area that Microsoft Excel 2007 has really improved upon.
Let's take a really quick look at how to create a chart with the data that we have here. Right now, I've got the EatCake Sales results for the quarters of last year. If I wanted to quickly see what this would look like as in a chart, I could go to my Insert tab, which is where my charting functions are stored, and I'm just going to quickly click on the Column chart, and I'm going to select this 2-D column stacked chart. And you'll see here that the information that we have in behind this chart is now nicely presented and is much easier to see that the WADE is my top performer, because it's now visually presented in a chart format.
Rather than having to search through and investigate all of the different information here in the table, I can easily see my high performers and my low performers, based on the information that's included here. Let's take a look at how we actually create this and in more detail.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 99029 Viewers
80 Video lessons · 141744 Viewers
59 Video lessons · 60111 Viewers
52 Video lessons · 73254 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.