Creating a Chart

Excel XP charts let you illustrate your workbook data graphically to see trends. Also use charts in Excel XP to visualize comparisons.

Creating an embedded chart

Charts can be created in one of two ways in Excel XP: embedded charts and chart sheets. Excel creates an embedded chart by default. An embedded chart is placed on the same worksheet as the source data that was used to create it.

To embed a chart in a worksheet:

  • Choose ViewToolbarsChart on the menu bar.
  • Select the range of cells you want to chart. Your source data should include at least three categories or numbers.

    Cell Range Selected for Charting
  • Click the chart type drop-down menu on the Chart toolbar and select the chart you want to use.

    Chart Drop-down Box
  • Open the chart options dialog box by clicking ChartOptions to add a title to your chart.

    Chart and Chart Options Menu Selections
  • Select the Titles tab, and type the title of the chart in the Chart Title text box.

    Chart Options Dialog Box

Different charts work best with different data. A pie chart, for example, can only display one data series at a time.

Excel XP includes a four-step Chart Wizard you can use to guide you through the steps for creating a chart. Highlight the cell range you want to chart, choose InsertChart on the menu bar, and follow the instructions in the wizard.