
For example, a better title for this chart might be The Performance of Motor and Other Rental Boats. Use a title that draws the viewers’ attention to the purpose of the chart: what you want them to see. On the Chart Elements page, you can give your chart a title and, if desired, a subtitle. Otherwise Calc will assume that you are adding to the same data series.Ĭlick Next to deal with titles, grids, and legends.Īdding or changing titles, legend, and grids The two data series you are selecting must be in separate columns or rows. Thus, to plot B3:B11 against G3:G11, type the selection range as B3:B11 G3:G11. The columns must be separated by semi-colons. Or you can type the columns in the text boxes. This is handy if your data ranges are larger than ours and the Chart Wizard is in the way.Īnother way to plot any unconnected columns of data is to select the first data series and then select the next series while holding down the Ctrl key. You can click the Shrink button next to the Range for Name box to work on the spreadsheet itself. For the moment, we will stick with the Column chart and click on Next again. The chart’s name is shown just below the icons. The current selection is highlighted (shown with a surrounding box) on the Choose a chart type page. The preview updates every time you select a different type of chart, and provides a good idea of what the finished chart will look like. On the Choose a chart type page, select a type by clicking on its icon. Only those types which are suitable for 3D (Column, Bar, Pie, and Area) give you an option to select a 3D look. The first tier of choice is for two-dimensional (2D) charts. Options vary according to the type of chart you pick. At any time you can go back to a previous step and change selections.Ĭalc offers a choice of 10 basic chart types, with a few options for each type of chart. The Chart Wizard has three main parts: a list of the steps involved in setting up the chart, the list of chart types, and the options for each chart type. This sample chart updates to reflect the changes you make in the Chart Wizard. The Chart Wizard includes a sample chart with your data. 4 Adding or changing titles, legend, and grids.
