Charts in $[officename]

Chart Data

Charts can be based on the following data:

Spreadsheet values from Calc cell rangesalso Excel... Cell values from a Writer table Values that you enter in the Chart Data Table dialog (you can create these charts in Writer, Draw, or Impress, and you can copy and paste them also to Calc)

command line Insert - (Object -) Chart, moved here from deleted shared/01/04160100.xhp

Creates a chart in the current document. To use a continuous range of cells as the data source for your chart, click inside the cell range, and then choose this command. Alternatively, select some cells and choose this command to create a chart of the selected cells.

To insert a chart

To edit a chart

Click a chart to edit the object properties: Size and position on the current page. Alignment, text wrap, outer borders, and more. Double-click a chart to enter the chart edit mode: Chart data values (for charts with own data). Chart type, axes, titles, walls, grid, and more. Double-click a chart element in chart edit mode: Double-click an axis to edit the scale, type, color, and more. Double-click a data point to select and edit the data series to which the data point belongs. With a data series selected, click, then double-click a single data point to edit the properties of this data point (for example, a single bar in a bar chart). Double-click the legend to select and edit the legend. Click, then double-click a symbol in the selected legend to edit the associated data series. Double-click any other chart element, or click the element and open the Format menu, to edit the properties. Click outside the chart to leave the current edit mode. To print a chart in high quality, you can export the chart to a PDF file and print that file. In chart edit mode, you see the Formatting Bar for charts near the upper border of the document. The Drawing Bar for charts appears near the lower border of the document. The Drawing Bar shows a subset of the icons from the Drawing toolbar of Draw and Impress. You can right-click an element of a chart to open the context menu. The context menu offers many commands to format the selected element.

Formats the selected title. Formats the chart area. Formats the chart wall. Formats the chart floor. Formats the chart legend. Formats the selected axis. Formats the selected data point. Formats the major grid. Formats the minor grid. Formats the data series. Formats the stock loss indicators. Formats the stock gain indicators. Formats the data labels. Formats the Y error bars. Formats the mean value line. Formats the trendline. Formats the trendline equation. Formats the selected data label. Opens a dialog to insert chart titles. Opens a dialog to insert or delete axes. Opens a dialog to insert an axis. Opens a dialog to insert an axis title. Inserts a major grid. Inserts a minor grid. Inserts data labels. Inserts the trendline equation and the coefficient of determination R². Inserts the coefficient of determination R² value. Inserts a single data label. Deletes the chart legend. Deletes the selected axis. Deletes the major grid. Deletes the minor grid. Deletes all data labels. Deletes the trendline equation. Deletes the R² value. Deletes the selected data label. Deletes the mean value line. Deletes the Y error bars. Resets the selected data point to default format. Resets all data points to default format.how to update chart data (drag&drop vs chart data dialog)