Select the range of cells you want to chart.Choose View Toolbars Chart on the menu bar.An embedded chart is placed on the same worksheet as the source data that was used to create it. Excel creates an embedded chart by default. Other charts that can be created in Excel 2003 include Doughnut Stock XY (scatter) Bubble Radar Surface and Cone, Cylinder, and Pyramid charts.Ĭharts can be created in either of two ways in Excel 2003: embedded charts and chart sheets. Pie charts are an effective way to display information when you want to represent different parts of the whole, or the percentages of a total. A line chart displays a series of points that are connected over time.Ī pie chart displays the contribution of each value to the total. Like the column chart, the bar chart shows variations in value over time.Ī line chart shows trends and variations in data over time. They are excellent at showing variations in value over time.Ī bar chart is similar to a column chart, except these use horizontal instead of vertical bars. An area chart also shows the relationship of parts to a whole.Ī column chart uses vertical bars or columns to display values over different categories. Area chartĪn area chart emphasizes the trend of each value over time. Then select the paintbrush icon, Chart Styles.Excel 2003 allows you to create many different kinds of charts. To change your pie chart color scheme, begin by selecting the pie chart. Legend Key: If you don’t have Category Name enabled, be sure to check this box so the legend appears at the bottom of your pie chart.Show Leader Lines: If the data label won’t fit entirely inside the slice, this option will add a line connecting the data label to the slice.What percentage of the whole pie does the slice represent? Checking this box will ensure that the slice is labeled with the percentage the slice represents. Percentage: This is often very useful.In our example, that’s the dollar amount each poker player won. Each slice of the pie is labeled with the data value corresponding to that slide. Instead of having to refer to the legend, this option will label each slice of the pie with the category values. Category Name: This one is recommended.In our example, each slice of the pie would get a label saying “Poker Winnings.” Series Name: Checking this option will add the heading of your data column to every slice of the pie.
0 kommentar(er)
