For a Column, Bar, Line, Area, Surface or Radar chart
Arrange your data in columns, like this:
| Lorem | Ipsum |
| 1 | 2 |
| 3 | 4 |
or in rows, like this:
| Lorem | 1 | 3 |
| Ipsum | 2 | 4 |
Regular pie charts (like the chart on the right in the example) have only one series of data, so you should use only one column of data. You can also use one column of labels for the data, like this:
| A | 1 |
| B | 2 |
| C | 3 |
or use one row of data, and, if you like, one row of labels:
| A | B | C |
| 1 | 2 | 3 |
Stacked pie charts and doughnut charts can have more than one series of data, so you can use more than one column of data, like this:
| A | 1 | 2 |
| B | 3 | 4 |
| C | 5 | 6 |
or more than one row of data, like this:
| A | B | C |
| 1 | 2 | 3 |
| 4 | 5 | 6 |
For an XY scatter or Bubble chart
Arrange your data in columns, with x values in the first column and corresponding y values and/or bubble size values in adjacent columns, like this:
| X | Y | Bubble |
| 1 | 2 | 3 |
| 4 | 5 | 6 |
Arrange your data in this order: high values, low values, and closing values. Use names or dates as labels, like this:
| Date | High | Low | Close |
| 1/1/2002 | 46.125 | 42 | 44.063 |
Customize your chart as you create it.
- Select the cells that contain the data you want to use for your chart.
- Click Chart Wizard
. - Follow the instructions in the Chart Wizard.
Create a basic chart that you can customize later.
- Display the Chart toolbar. To show the Chart toolbar, point to Toolbars on the View menu and then click Chart.
- Select the cells that contain the data you want to use for your chart.
- Click Chart Type
.
If the cells you want to select for your chart are not in a continuous range, do the following:
Select the first group of cells that contain the data you want to include. While holding down CTRL, select any additional cell groups you want to include. The nonadjacent selections must form a rectangle.
