Creating charts automatically
Creating a chart lets you represent spreadsheet data graphically. You can create a chart automatically and have all the chart options chosen for you, or you can create a chart by using the Chart Expert, which guides you through the steps of creating a chart that best suits a data set.
For information about editing charts, see “Editing charts.”
To create a chart automatically |  |
|
1.
|
|
Select the cells you want to plot.
|
|
If the surrounding cells contain explanatory labels, you can include them in the selection for use as the chart axis labels or the chart legend.
|
|
2.
|
|
Click the Chart button on the toolbar, and choose Create QuickChart.
|
|
3.
|
|
On the spreadsheet, click where you want to insert the chart.
|
|
•
|
|
When you create a chart automatically, it is placed on the spreadsheet in a floating graphics window; however, you can view it on its own page. For information about viewing a chart on its own page, see “Managing and sharing graphics.”
|
|
•
|
|
If you want to customize the size of the chart, click and drag diagonally on the spreadsheet.
|
|
•
|
|
If the cells you select contain dates, you can display the dates on the x or y axes by changing the numeric format to Date. For more information about displaying dates on the axes, see “Setting the numeric format for the x and y axes.”
|
To create a chart by using the Chart Expert | |
|
1.
|
|
Click Insert
 Chart Use Chart Expert. |
|
2.
|
|
Follow the steps of the Expert.
|
|
•
|
|
If the cells you select contain dates, you can display the dates on the x or y axes by changing the numeric format to Date. For more information about displaying dates on the axes, see “Setting the numeric format for the x and y axes.”
|