how to make a line graph in openoffice calc

How to make a line graph in openoffice calc series#

In the Data Ranges list box you see the role names and cell ranges of the data series components.Ĭlick an entry, then edit the contents in the text box below.

This does not change the order in the data source table, but changes only the arrangement in the chart.Ĭlick an entry in the list to view and edit the properties for that entry. This way you can convert a Column data series to a List data series and back. Use the Up and Down arrow buttons to move the selected entry in the list up or down. The new data series has the same type as the selected entry.Ĭlick Remove to remove the selected entry from the Data Series list. To organize the data series, select an entry in the list.Ĭlick Add to add another data series below the selected entry. The column data series are positioned at the top of the list, the line data series at the bottom of the list. In the Data Series list box you see a list of all data series in the current chart. You can change this assignment in the Data Series dialog.Ĭlick one of the options for data series in rows or in columns.Ĭheck whether the data range has labels in the first row or in the first column or both. The other columns or rows of the data range provide the data for the Lines objects. The leftmost columns (or the top rows) of the selected data range provide the data that are shown as Columns objects. You can insert a second y-axis with Insert - Axes after you finish the wizard. The rectangles of the column data series are drawn stacked above each other, so that the height of a column visualizes the sum of the data values. The rectangles of the column data series are drawn side by side so that you can easily compare their values. A Column and Line chart is a combination of a Column chart with a Line chart.Ĭolumns and Lines.

How to make a line graph in openoffice calc