Creating a Chart Object and a Chart Sheet.pdf - Excel Chapter 3 Creating and Editing Charts SLO 3.1 Creating a Chart Object and a Chart Sheet An Excel

Creating a Chart Object and a Chart Sheet.pdf - Excel...

This preview shows page 1 - 2 out of 6 pages.

Excel - Chapter 3 - Creating and Editing Charts SLO 3.1 Creating a Chart Object and a Chart Sheet An 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, so when values in the worksheet change, the chart is automatically redrawn. You can display a chart in the worksheet 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 selected data. It is essential, however, that you select appropriate data for a chart, because it is possible to build charts that illustrate nothing of any consequence. With experience and practice, you will learn how to create charts that have meaning to your work. Create a Chart Object A chart object is a selectable item surrounded by a square border that is separate from worksheet data. A chart 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 on the chart. Source data are the cells that contain values and labels to be graphed in a chart. When you select data for a chart, you usually do not include sums, averages, or similar calculations. In Figure 3-1, the source data includes the series names in column A, the category names in row 4, and four values for each of three months. Each of the values is a data point , a cell containing a value. Each group of data points or values is a data series . In this example, there are four data series, one for each revenue category. Each data series has a name or label. The text label that describes a data series is a category label . In Figure 3.1, the category labels are the month names. ANOTHER WAY You 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 not include labels for the source data, there are no labels in the chart to describe the data. An empty row within the source data is graphed as a data point with a value of zero (0) and will distort the chart’s ability to illustrate a comparison or trend.
Image of page 1
Image of page 2

You've reached the end of your free preview.

Want to read all 6 pages?

  • Summer '15

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture