On the Command bar, from the Chart menu, select Source Data.
The Edit Series dialog box closes and the Edit Data Source dialog box appears.
In the Series name text box, type the name of the series.ĮXAMPLE: In a line chart of students' grades, a series name would be the student's name. The Edit Data Source dialog box closes and the Edit Series dialog box appears. NOTE: You may add a data series only in the x-axis of your chart. Right click the chart » click Edit Data Source.įrom the Design command tab, in the Data group, click Edit Data Source. You can add an additional data series to an existing chart.īefore you begin, you should enter this added data into your worksheet.Īdding a data series to a chart does not move it to the information used to create the chart. To type a range, type the range's initial cell's ID, a colon, and the range's final cell's ID.ĮXAMPLE: The data range B2:B5 references the the cells B2, B3, B4, and B5. If you need to delete or change the references to the cells containing the information, you will need to edit the data series.Ī data range is a range of cells that contain data in a data series. Another data series may contain the forecasted enrollment for the next academic year. For example, a data series may contain the enrollment, by school, for the current academic year. On the right, in the chart type section, select the specific chart you want.įrom the Elements Gallery, select the specific chart you want.Ī data series identifies the information charted. Right click your chart » select Change Chart Type.įrom the categories pane, select the type of chart you prefer. If the chart you selected is not appropriate for the information you are charting, you can simply change it.
For more information, refer to Working with Chart Elements ( Windows | Macintosh) or Formatting Your Chart ( Windows | Macintosh). Once your chart is created, you can modify it to fit your needs or any changes in your data. (Optional) If the information is represented on the incorrect axes, from the Formatting Palette, expand Chart Data » click to sort by Row or click to sort by Column. (Optional) If the information is represented on the incorrect axes, in the Design command tab, from the Data group, click Switch Row/Column.įrom the Elements Gallery, select the Charts tab » click the type of chart you prefer. The Design, Layout, and Format command tabs appear on the Ribbon. NOTE: For information on the various chart types, refer to Guidelines for Charting. NOTE: To select data from different areas of your worksheet or to select non-contiguous cells:įrom the Insert command tab, in the Charts group, click the type of chart you prefer.
There are many types of charts available, so you should find the appropriate one for your project.įor information about entering data in Excel, refer to Getting Started with Excel. In Excel, charts are visual representations of data on a spreadsheet.
This document shows you how to create a chart and perform basic editing. With a few clicks, Excel will create a basic chart you can edit and enhance to meet your needs.
Microsoft Excel 2007/2008 makes creating charts simple. This article is based on legacy software.
In columns or rows, using a combination of opening, high, low, and closing values, plus names or dates as labels in the right order.(Archives) Microsoft Excel 2007: Creating a Basic Chart In columns, placing your x values in the first column and your y values in the next column.įor bubble charts, add a third column to specify the size of the bubbles it shows, to represent the data points in the data series. In one or multiple columns or rows of data, and one column or row of labels. This chart can use one or more data series. In one column or row, and one column or row of labels. This chart uses one set of values (called a data series). Either way, this table lists the best ways to arrange your data for a given chart.Ĭolumn, bar, line, area, surface, or radar chart You also may have your own charts in mind. The charts it suggests depend on how you’ve arranged the data in your worksheet. Arrange data for chartsĮxcel can recommend charts for you. Tip: If you don't want to include specific rows or columns of data in a chart, you can simply hide them on the worksheet, or you can apply chart filters to show the data points you want after you create the chart.