They help you understand relation between X and Why values. Scatter also known as xy chart are useful in mathematical and scientific settings. This is the one be used for our personal budget.
The pie chart is beneficial in understanding breakdown and allocation of quantity. Line and area charts are useful to show trends or time for example a stock price Chart displayed or time.
Bar chart has the same effect as column chart except in shows the data across the horizontal axis stepped off the where to call axis. Column chart is the most common type of chart and is typically used to plot data against categories for example product types, Sales quarters etc. Here is a brief description on the chart types: I want to explain the different type of charts in Microsoft Excel 2007 before moving onto of the next group. I like Layout 6 with the chart title on top and the chart legend on the right side so I picked this one.Īnother cool feature I like about this chart layout is that our expenses are now broken down by percentage so my mortgage is 33%of my total expenses, I need a new house!! Here are the screen shots from the Chart layouts exercise.ĭifferent type of charts in Microsoft Excel 2007 From the Chart Layouts group, I was able to see a few predefined layouts when I selected the drop down list. Moving on I want to change the overall chart layout so I am able to see the Chart Title. Here is the command and the outcome of this action in the following two figures. How about style 42 of the black background? I like it so I will go ahead and select it and then click OK. I would like to use a strong color for the background instead of the plain white one that we currently have. Using the Chart Styles group, I can easily change the color scheme of my pie chart. Let’s explore the Design Tab a little bit more. Let us go ahead and save our personal budget workbook for now before proceeding onwords. Now we are able to see the breakdown of our expenses by different color and size of the pie. I think this looks a lot better than the 2-D bar chart that we had earlier. I will go ahead and choose 3-D Pie and then click on OK. Here is a screen capture right below. If I click on Change Chart Type, it will open up a new dialog box shown as below Before we study the functionality under these tabs, I would like to switch my chart to maybe another chart type. These tabs will let you fine tune your chart settings even further. If you look closely, there are three tabs including Design, Layout and Format under the Chart Tools Menu. Finally it enabled the Chart Tools contextual menu in the Tile bar. And also it inserted a generic a legend on the right side of our chart. Microsoft Excel also generated the data points for my horizontal and vertical axes. Now we can easily tell that Mortgage is by far my biggest expense followed by the car payment, credit cards and groceries, etc. Here is a screen capture of this action right below. Then go to Insert Tab, click on column in the charts group and select 2-D clustered column from the dropdown. You will notice that we have a host of column charting options in the dropdown with a Live preview feature, Very Nice! After I made my selection, it generated a 2-D clustered column chart in our Excel workbook. Go ahead and click anywhere in the expenses section. We can easily create a chart that would answer this question. Let us say we would like to know the top expenses in my budget. We can easily do this by utilizing one of the many charts available in Microsoft Excel 2007. In our scenario what if we wanted to get the graphical representation of our budget data. Like the expression “A picture is worth 1000 words”, we can use this to our advantage in understanding the numbers. When working with any numerical data, you can use charts to get important visual clues about the underlying information. So for now we will skip over the other groups and focus on the charts first. I feel the charts functionality in Microsoft Excel 2007 is a vital concept to grasp. Today I am not going to follow the groups in order as we have done in the past. I have split my workbook into three sections, income, expenditures and balance. You can insert things pictures, clip art images, smart art graphics, charts, Pivot tables, hyperlinks, header and footer sections, etc using this Tab. The Insert Tab has the following groups that you can utilize to insert objects:įor our lesson today we will be using my personal budget workbook. The Insert Tab in Microsoft Excel 2007 will let you add external objects in your workbook. Microsoft Excel 2007 Tutorial – Insert Tab
0 kommentar(er)
