50%(2)1 out of 2 people found this document helpful
This preview shows page 1 - 2 out of 6 pages.
Excel - Chapter 3 - Creating and Editing ChartsSLO 3.1Creating a Chart Object and a Chart SheetAn Excel chart is a visual representation of numeric data in a worksheet. A chart helps you identify trends,make comparisons, and recognize patterns in the numbers. Charts are dynamic and linked to the data, sowhen values in the worksheet change, the chart is automatically redrawn. You can display a chart in theworksheet with its data, or you can place a chart on its own sheet.There are different kinds of charts, and Excel can recommend the best chart type based on your selecteddata. It is essential, however, that you select appropriate data for a chart, because it is possible to build chartsthat illustrate nothing of any consequence. With experience and practice, you will learn how to create chartsthat have meaning to your work.Create a Chart ObjectA chart object is a selectable item surrounded by a square border that is separate from worksheet data. Achart object contains chart elements such as titles, axes, and gridlines, and each element is selectable, too.You can size and position a chart object in a worksheet, and you can size and position each chart element onthe chart.Source data are the cells that contain values and labels to be graphed in a chart. When you select data fora chart, you usually do not include sums, averages, or similar calculations. In Figure 3-1, the source dataincludes the series names in column A, the category names in row 4, and four values for each of threemonths. Each of the values is a data point, a cell containing a value. Each group of data points or values is adata series. In this example, there are four data series, one for each revenue category. Each data series has aname or label.The text label that describes a data series is a category label. In Figure 3.1, the category labels are themonth names.ANOTHER WAYYou can create a default chart object by selecting the data and pressing Alt+F1.Data for a chart is best arranged with labels and values in adjacent cells and no empty rows. If you do notinclude labels for the source data, there are no labels in the chart to describe the data. An empty row withinthe source data is graphed as a data point with a value of zero (0) and will distort the chart’s ability to illustratea comparison or trend.