Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc User Guide
Previous Page Home Next Page

Data range and labels

The data range includes the numbers that we wish to chart. The checked boxes indicate that Calc has recognized that the entries in the first column and the first row are not numbers and it is suggesting that we may want to use them to supply labels (names). We will accept the suggestion.

The labels in the First column will be used to label the x-axis and the labels in the first row will be used in the Legend. If we did not want to use these labels we could uncheck the boxes and Calc would just ignore the column and the row in creating the chart.

To select the type of chart or graph required, click Next.


If the AutoFormat Chart dialog was opened from the Insert menu, the Chart results in worksheet option is available. From this list box you can select the sheet on which the new chart will reside. Opening the dialog from the toolbars requires you to select a location for the new chart before it is opened, so this list box is not available. Since the data range is specified in Absolute references no matter where the new chart is placed in the current spreadsheet, it will update as the data change in the source ranges.


Calc offers a choice of 13 different main chart types, a mixture of 2-dimensional and faux 3-dimensional types. Only 8 of the 13 types are shown; scroll down to see the other selections.

On the Choose a chart type (Figure 43) page, select one by clicking on its icon. To view a preview of the chart that displays the title, labels and legend, select the Show text elements in preview checkbox at the left of the dialog. This preview will update every time you select a different type of chart, and provides you with a good idea of what your finished chart will look like.

The current selection, shown with a border around it, is the Columns chart. The selected chart’s name is shown just below the icons. For the moment, we will stick with the Columns chart and click on Next again.

This takes us to the Choose a Variant page (not shown here) where we have a choice of five different types of column chart. Again we need to scroll down to see all the choices. We will stay with the suggested format, Normal, and click on Next again.

OpenOffice Calc User Guide
Previous Page Home Next Page

  Published under the terms of the Open Publication License Design by Interspire