Articles with the tag:
Close
Changelog
Close
Articles with the tag:
Close
Try in the cloud
Try in the cloud

Insert charts

Insert a chart

To insert a chart in the Document Editor,

  1. Place the cursor where the chart should be added.
  2. Switch to the Insert tab of the top toolbar.
  3. Click the
    Chart icon on the top toolbar.
  4. Select the needed chart type from the available ones:
    Column Charts
    • Clustered column
    • Stacked column
    • 100% stacked column
    • 3-D Clustered Column
    • 3-D Stacked Column
    • 3-D 100% stacked column
    • 3-D Column
    Line Charts
    • Line
    • Stacked line
    • 100% stacked line
    • Line with markers
    • Stacked line with markers
    • 100% stacked line with markers
    • 3-D Line
    Pie Charts
    • Pie
    • Doughnut
    • 3-D Pie
    Bar Charts
    • Clustered bar
    • Stacked bar
    • 100% stacked bar
    • 3-D clustered bar
    • 3-D stacked bar
    • 3-D 100% stacked bar
    Area Charts
    • Area
    • Stacked area
    • 100% stacked area
    Stock Charts
    XY (Scatter) Charts
    • Scatter
    • Stacked bar
    • Scatter with smooth lines and markers
    • Scatter with smooth lines
    • Scatter with straight lines and markers
    • Scatter with straight lines
    Radar Charts
    • Radar
    • Radar with markers
    • Filled radar
    Combo Charts
    • Clustered column - line
    • Clustered column - line on secondary axis
    • Stacked area - clustered column
    • Custom combination

    Note: ONLYOFFICE Document Editor supports the following types of charts that were created with third-party editors: Pyramid, Bar (Pyramid), Horizontal/Vertical Cylinders, Horizontal/Vertical Cones. You can open the file containing such a chart and modify it using the available chart editing tools.

  5. After that the Chart Editor window will appear where you can enter the necessary data into the cells using the following controls:
    • and
      for copying and pasting the copied data
    • and
      for undoing and redoing actions
    • for inserting a function
    • and
      for decreasing and increasing decimal places
    • Number format for changing the number format, i.e. the way the numbers you enter appear in cells
    • Chart Type for choosing a different type of chart.

    Chart Editor window

  6. Click the Select data button situated in the Chart Editor window. The Chart data window will open.
    1. Use the Chart data dialog to manage Chart data range, Legend entries (Series), Horizontal (category) axis label and Switch row/column.

      Chart Data window

      • Chart data range - select data for your chart.
        • Click the
          icon on the right of the Chart data range box to select data range.

          Select Data Range window

      • Legend entries (series) - add, edit, or remove legend entries. Type or select series name for legend entries.
        • In Legend entries (series), click Add button.
        • In Edit series, type a new legend entry or click the
          icon on the right of the Select name box.

          Edit Series window

      • Horizontal (category) axis labels - change text for category labels.
        • In Horizontal (category) axis labels, click Edit.
        • In Axis label range, type the labels you want to add or click the
          icon on the right of the Axis label range box to select data range.

          Axis Labels window

      • Switch row/column - rearrange the worksheet data that is configured in the chart not in the way that you want it. Switch rows to columns to display data on a different axis.
    2. Click OK button to apply the changes and close the window.
  7. Click the Change Chart Type button in the Chart Editor window to choose chart type and style. Select a chart from the available sections: Column, Line, Pie, Bar, Area, Stock, XY (Scatter), Radar, or Combo.

    Chart Type window

    When you choose Combo Charts, the Chart type window lists chart series and allows choosing the types of charts to combine and selecting data series to place on a secondary axis.

    Chart Type Combo

  8. Change the chart settings by clicking the Edit Chart button situated in the Chart Editor window. The Chart - Advanced Settings window will open.

    Chart - Advanced Settings window

    The Layout tab allows you to change the layout of chart elements.

    • Specify the Chart title position in regard to your chart selecting the necessary option from the drop-down list:
      • None to display no chart title,
      • Overlay to overlay and center a title on the plot area,
      • No overlay to display the title above the plot area.
    • Specify the Legend position in regard to your chart selecting the necessary option from the drop-down list:
      • None to display no legend,
      • Bottom to display the legend and align it to the bottom of the plot area,
      • Top to display the legend and align it to the top of the plot area,
      • Right to display the legend and align it to the right of the plot area,
      • Left to display the legend and align it to the left of the plot area,
      • Left overlay to overlay and center the legend to the left on the plot area,
      • Right overlay to overlay and center the legend to the right on the plot area.
    • Specify the Data labels (i.e. text labels that represent exact values of data points) parameters:
      • Specify the Data labels position relative to the data points selecting the necessary option from the drop-down list. The available options vary depending on the selected chart type.
        • For Column/Bar charts, you can choose the following options: None, Center, Inner bottom, Inner top, Outer top.
        • For Line/XY (Scatter)/Stock charts, you can choose the following options: None, Center, Left, Right, Top, Bottom.
        • For Pie charts, you can choose the following options: None, Center, Fit to width, Inner top, Outer top.
        • For Area charts as well as for 3D Column, Line, Bar, Radar, and Combo charts, you can choose the following options: None, Center.
      • Select the data you wish to include into your labels checking the corresponding boxes: Series name, Category name, Value,
      • Enter a character (comma, semicolon etc.) you wish to use for separating several labels into the Data labels separator entry field.
    • Lines - is used to choose a line style for Line/XY (Scatter) charts. You can choose one of the following options: Straight to use straight lines between data points, Smooth to use smooth curves between data points, or None to not display lines.
    • Markers - is used to specify whether the markers should be displayed (if the box is checked) or not (if the box is unchecked) for Line/XY (Scatter) charts.

      Note: the Lines and Markers options are available for Line charts and XY (Scatter) charts only.

    Chart - Advanced Settings window

    The Vertical axis tab allows you to change the parameters of the vertical axis also referred to as the values axis or y-axis which displays numeric values. Note that the vertical axis will be the category axis which displays text labels for the Bar charts, therefore in this case the Vertical axis tab options will correspond to the ones described in the next section. For the XY (Scatter) charts, both axes are value axes.

    Note: the Axis Settings and Gridlines sections will be disabled for Pie charts since charts of this type have no axes and gridlines.

    • Select Hide to hide vertical axis in the chart, leave it unchecked to have vertical axis displayed.
    • Specify Title orientation by selecting the necessary option from the drop-down list:
      • None to not display a vertical axis title
      • Rotated to display the title from bottom to top to the left of the vertical axis,
      • Horizontal to display the title horizontally to the left of the vertical axis.
    • Minimum value - is used to specify the lowest value displayed at the vertical axis start. The Auto option is selected by default, in this case the minimum value is calculated automatically depending on the selected data range. You can select the Fixed option from the drop-down list and specify a different value in the entry field on the right.
    • Maximum value - is used to specify the highest value displayed at the vertical axis end. The Auto option is selected by default, in this case the maximum value is calculated automatically depending on the selected data range. You can select the Fixed option from the drop-down list and specify a different value in the entry field on the right.
    • Axis crosses - is used to specify a point on the vertical axis where the horizontal axis should cross it. The Auto option is selected by default, in this case the axes intersection point value is calculated automatically depending on the selected data range. You can select the Value option from the drop-down list and specify a different value in the entry field on the right, or set the axes intersection point at the Minimum/Maximum Value on the vertical axis.
    • Display units - is used to determine the representation of the numeric values along the vertical axis. This option can be useful if you're working with great numbers and wish the values on the axis to be displayed in a more compact and readable way (e.g. you can represent 50 000 as 50 by using the Thousands display units). Select desired units from the drop-down list: Hundreds, Thousands, 10 000, 100 000, Millions, 10 000 000, 100 000 000, Billions, Trillions, or choose the None option to return to the default units.
    • Values in reverse order - is used to display values in the opposite direction. When the box is unchecked, the lowest value is at the bottom and the highest value is at the top of the axis. When the box is checked, the values are ordered from top to bottom.
    • Logarithmic scale - is used to enable logarithmic scaling to the Base that is determined by the user.
    • The Tick Options section allows adjusting the appearance of tick marks on the vertical scale. Major tick marks are the larger scale divisions which can have labels displaying numeric values. Minor tick marks are the scale subdivisions which are placed between the major tick marks and have no labels. Tick marks also define where gridlines can be displayed if the corresponding option is set on the Layout tab. The Major/minor type drop-down lists contain the following placement options:
      • None to display no major/minor tick marks,
      • Cross to display major/minor tick marks on both sides of the axis,
      • In to display major/minor tick marks inside the axis,
      • Out to display major/minor tick marks outside the axis.
    • The Label options section allows adjusting the appearance of major tick mark labels which display values. To specify a Label position in regard to the vertical axis, select the necessary option from the drop-down list:
      • None to not display tick mark labels,
      • Low to display tick mark labels to the left of the plot area,
      • High to display tick mark labels to the right of the plot area,
      • Next to axis to display tick mark labels next to the axis.
      • To specify a Label format click the Label format button and choose a category as deemed appropriate.

        Available label format categories:

        • General
        • Number
        • Scientific
        • Accounting
        • Currency
        • Date
        • Time
        • Percentage
        • Fraction
        • Text
        • Custom

        Label format options vary depending on the selected category. For more information on changing number format, go to this page.

      • Check Linked to source to keep number formatting from the data source in the chart.

    Chart - Advanced Settings window

    Note: Secondary axes are supported in Combo charts only.

    Secondary axes are useful in Combo charts when data series vary considerably or mixed types of data are used to plot a chart. Secondary Axes make it easier to read and understand a combo chart.

    The Secondary vertical/horizontal axis tab appears when you choose an appropriate data series for a combo chart. All the settings and options on the Secondary vertical/horizontal axis tab are the same as the settings on the vertical/horizontal axis. For a detailed description of the Vertical/horizontal axis options, see description above/below.

    Chart - Advanced Settings window

    The Horizontal axis tab allows you to change the parameters of the horizontal axis also referred to as the categories axis or x-axis which displays text labels. Note that the horizontal axis will be the value axis which displays numeric values for the Bar charts, therefore in this case the Horizontal axis tab options will correspond to the ones described in the previous section. For the XY (Scatter) charts, both axes are value axes.

    • Select Hide to hide horizontal axis in the chart, leave it unchecked to have horizontal axis displayed.
    • Specify Title orientation by selecting the necessary option from the drop-down list:
      • None to display no horizontal axis title,
      • No overlay to display the title below the horizontal axis,
    • Gridlines are used to specify the Horizontal gridlines to display by selecting the necessary option from the drop-down list: None,  MajorMinor, or Major and minor.
    • Axis crosses - is used to specify a point on the horizontal axis where the vertical axis should cross it. The Auto option is selected by default, in this case the axes intersection point value is calculated automatically depending on the selected data range. You can select the Value option from the drop-down list and specify a different value in the entry field on the right, or set the axes intersection point at the Minimum/maximum value (that corresponds to the first and last category) on the horizontal axis.
    • Axis position - is used to specify where the axis text labels should be placed: On tick marks or Between tick marks.
    • Values in reverse order - is used to display categories in the opposite direction. When the box is unchecked, categories are displayed from left to right. When the box is checked, the categories are ordered from right to left.
    • The Tick Options section allows adjusting the appearance of tick marks on the horizontal scale. Major tick marks are the larger divisions which can have labels displaying category values. Minor tick marks are the smaller divisions which are placed between the major tick marks and have no labels. Tick marks also define where gridlines can be displayed if the corresponding option is set on the Layout tab. You can adjust the following tick mark parameters:
      • Major/minor type - is used to specify the following placement options: None to not display major/minor tick marks, Cross to display major/minor tick marks on both sides of the axis, In to display major/minor tick marks inside the axis, Out to display major/minor tick marks outside the axis.
      • Interval between marks - is used to specify how many categories should be displayed between two adjacent tick marks.
    • The Label Options section allows adjusting the appearance of labels which display categories.
      • Label position - is used to specify where the labels should be placed in regard to the horizontal axis. Select the necessary option from the drop-down list: None to not display category labels, Low to display category labels at the bottom of the plot area, High to display category labels at the top of the plot area, Next to axis to display category labels next to the axis.
      • Axis label distance - is used to specify how closely the labels should be placed to the axis. You can specify the necessary value in the entry field. The more the value you set, the more the distance between the axis and labels is.
      • Interval between labels - is used to specify how often the labels should be displayed. The Auto option is selected by default, in this case labels are displayed for every category. You can select the Manual option from the drop-down list and specify the necessary value in the entry field on the right. For example, enter 2 to display labels for every other category etc.
      • To specify a Label format click the Label format button and choose a category as deemed appropriate.

        Available label format categories:

        • General
        • Number
        • Scientific
        • Accounting
        • Currency
        • Date
        • Time
        • Percentage
        • Fraction
        • Text
        • Custom

        Label format options vary depending on the selected category. For more information on changing number format, go to this page.

      • Check Linked to source to keep number formatting from the data source in the chart.

    Chart - Advanced Settings: Cell Snapping

    The Cell snapping tab contains the following parameters:

    • Move and size with cells - this option allows you to snap the chart to the cell behind it. If the cell moves (e.g. if you insert or delete some rows/columns), the chart will be moved together with the cell. If you increase or decrease the width or height of the cell, the chart will change its size as well.
    • Move but don't size with cells - this option allows to snap the chart to the cell behind it preventing the chart from being resized. If the cell moves, the chart will be moved together with the cell, but if you change the cell size, the chart dimensions remain unchanged.
    • Don't move or size with cells - this option allows to prevent the chart from being moved or resized if the cell position or size was changed.

    Chart - Advanced Settings

    The Alternative text tab allows specifying a Title and Description which will be read to people with vision or cognitive impairments to help them better understand what information the chart contains.


Move and resize charts

Moving chartOnce the chart is added, you can change its size and position. To change the chart size, drag small squares situated on its edges. To maintain the original proportions of the selected chart while resizing, hold down the Shift key and drag one of the corner icons.

To alter the chart position, use the icon that appears after hovering your mouse cursor over the chart. Drag the chart to the necessary position without releasing the mouse button. When you move the chart, guide lines are displayed to help you position the object on the page precisely (if a wrapping style other than inline is selected).

Note: the list of keyboard shortcuts that can be used when working with objects is available here.


Edit chart elements

To edit the chart Title, select the default text with the mouse and type the required text.

To change the font formatting within text elements, such as the chart title, axes titles, legend entries, data labels etc., select the necessary text element by left-clicking it. Then use the corresponding icons on the Home tab of the top toolbar to change the font type, size, color or its decoration style.

When the chart is selected, the Shape settings icon is also available on the right, since a shape is used as a background for the chart. You can click this icon to open the Shape settings tab on the right sidebar and adjust Fill and Line of the shape. Note that you cannot change the shape type.

Using the Shape settings tab on the right panel, you can both adjust the chart area itself and change the chart elements, such as plot area, data series, chart title, legend etc and apply different fill types to them. Select the chart element clicking it with the left mouse button and choose the preferred fill type: solid color, gradient, texture or picture, pattern. Specify the fill parameters and set the Opacity level if necessary. When you select a vertical or horizontal axis or gridlines, the stroke settings are only available at the Shape settings tab: color, width, type, and opacity. For more details on how to work with shape colors, fills and stroke, you can refer to this page.

Note: the Show shadow option is also available at the Shape settings tab, but it is disabled for chart elements.

If you need to resize chart elements, left-click to select the needed element and drag one of 8 white squares located along the perimeter of the element.

To change the position of the element, left-click on it, make sure your cursor changed to , hold the left mouse button and drag the element to the needed position.

To delete a chart element, select it by left-clicking and press the Delete key on the keyboard.

You can also rotate 3D charts using the mouse. Left-click within the plot area and hold the mouse button. Drag the cursor without releasing the mouse button to change the 3D chart orientation.

3D chart


Adjust chart settings

Chart Settings tab

Some of the chart settings can be altered using the Chart settings tab of the right sidebar. To activate it click the chart and choose the Chart settings icon on the right. Here you can change the following properties:

  • Size is used to view the Width and Height of the current chart.
  • Wrapping Style is used to select a text wrapping style from the available ones - inline, square, tight, through, top and bottom, in front, behind (for more information see the advanced settings description below).
  • Change Chart Type is used to change the selected chart type and/or style.

    To select the necessary chart Style, use the second drop-down menu in the Change Chart Type section.

  • Edit Data is used to open the 'Chart Editor' window.

    Note: to quickly open the 'Chart Editor' window you can also double-click the chart in the document.

You can also find some of these options in the right-click menu. The menu options are:

  • Cut, Copy, Paste - standard options which are used to cut or copy the selected text/object and paste the previously cut/copied text passage or object to the current cursor position.
  • Arrange is used to bring the selected chart to foreground, send it to the background, move forward or backward as well as group or ungroup charts to perform operations with several of them at once. To learn more on how to arrange objects, please refer to this page.
  • Align is used to align the chart left, center, right, top, middle, bottom. To learn more on how to align objects you can refer to this page.
  • Wrapping Style is used to select a text wrapping style from the available ones - inline, square, tight, through, top and bottom, in front, behind. The Edit Wrap Boundary option is unavailable for charts.
  • Edit Data is used to open the 'Chart Editor' window.
  • Chart Advanced Settings is used to open the 'Chart - Advanced Settings' window.

Additionally, 3D Rotation settings are available for 3D charts:

Chart Settings tab

  • X rotation - set the required value for the X axis rotation using the keyboard or via the Left and Right arrows to the right.
  • Y rotation - set the required value for the Y axis rotation using the keyboard or via the Up and Down arrows to the right.
  • Perspective - set the required value for depth rotation using the keyboard or via the Narrow field of view and Widen field of view arrows to the right.
  • Right Angle Axis - is used to set the right angle axis view.
  • Autoscale - check this box to autoscale the depth and height values of the chart, or uncheck this box to set the depth and height values manually.
  • Depth (% of base) - set the required depth value using the keyboard or via the arrows.
  • Height (% of base) - set the required height value using the keyboard or via the arrows.
  • Default Rotation - set the 3D parameters to their default.

    Please note that you cannot edit each element of the chart; the settings will be applied to the chart as a whole.


To change the chart advanced settings, click the needed chart with the right mouse button and select Chart Advanced Settings from the right-click menu or just click the Show advanced settings link on the right sidebar. The chart properties window will open:

Chart - Advanced Settings: Size

The Size tab contains the following parameters:

  • Width and Height - use these options to change the width and/or height of the chart. If the Constant Proportions
    button is clicked (in this case it looks like this
    ), the width and height will be changed together preserving the original chart aspect ratio.

Chart - Advanced Settings: Text Wrapping

The Text Wrapping tab contains the following parameters:

  • Wrapping Style - use this option to change the way the chart is positioned relative to the text: it will either be a part of the text (in case you select the inline style) or bypassed by it from all sides (if you select one of the other styles).
    • Inline - the chart is considered to be a part of the text, like a character, so when the text moves, the chart moves as well. In this case the positioning options are inaccessible.

      If one of the following styles is selected, the chart can be moved independently of the text and positioned on the page exactly:

    • Square - the text wraps the rectangular box that bounds the chart.

    • Tight - the text wraps the actual chart edges.

    • Through - the text wraps around the chart edges and fills in the open white space within the chart.

    • Top and bottom - the text is only above and below the chart.

    • In front - the chart overlaps the text.

    • Behind - the text overlaps the chart.

If you select the square, tight, through, or top and bottom styles, you will be able to set up some additional parameters - distance from text at all sides (top, bottom, left, right).

Chart - Advanced Settings: Position

The Position tab is available only if the selected wrapping style is not inline. This tab contains the following parameters that vary depending on the selected wrapping style:

  • The Horizontal section allows you to select one of the following three chart positioning types:
    • Alignment (left, center, right) relative to character, column, left margin, margin, page or right margin,
    • Absolute Position measured in absolute units i.e. Centimeters/Points/Inches (depending on the option specified on the File -> Advanced Settings... tab) to the right of character, column, left margin, margin, page or right margin,
    • Relative position measured in percent relative to the left margin, margin, page or right margin.
  • The Vertical section allows you to select one of the following three chart positioning types:
    • Alignment (top, center, bottom) relative to line, margin, bottom margin, paragraph, page or top margin,
    • Absolute Position measured in absolute units i.e. Centimeters/Points/Inches (depending on the option specified on the File -> Advanced Settings... tab) below line, margin, bottom margin, paragraph, page or top margin,
    • Relative position measured in percent relative to the margin, bottom margin, page or top margin.
  • Move object with text ensures that the chart moves along with the text to which it is anchored.
  • Allow overlap makes it possible for two charts to overlap if you drag them near each other on the page.

Chart - Advanced Settings

The Alternative Text tab allows specifying a Title and Description which will be read to the people with vision or cognitive impairments to help them better understand what information the chart contains.

Return to previous page
Try now for free Try and make your decision No need to install anything
to see all the features in action