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

Adjust chart settings

Edit chart data and adjust chart settings

Currently, you can change the data used to create a chart as well as adjust the appearance of a chart in an existing document.

The most common functions are grouped in a quick access panel as shown below:

quick access panel chart

  1. Select the chart by tapping it.
  2. Open the Chart Editor window by selecting the Edit Data option in the pop-up menu.
  3. Within the Chart Editor window, change the data in the cells or access the chart settings panel by tapping the Edit chart icon at the top toolbar.

    Chart Editor window

  4. Tap the Open settings arrow next to the necessary menu item: Style, Layout, Vertical Axis, Horizontal Axis, or Reorder.

    The Style section contains the following four tabs:

    • Type - to change the current chart type (line chart, column chart, bar chart, area chart, pie chart, point chart, or stock chart). Swipe right or left to see all the chart types and tap the one you want to apply.
    • Style - to change the current chart style. Swipe right or left to see all the available styles and tap the one you want to apply.
    • Fill - to change the chart background fill by selecting a solid color, gradient template or predefined texture. Swipe right or left to see all the palettes and tap the fill you want to use.
    • Border - to adjust the chart border Size and select its Color on the palette.

    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:
      • None to not display a 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:
      • None to not display a 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.
    • The AXIS TITLE section allows to specify Horizontal/Vertical axis title parameters:
      • Specify if you wish to display the Horizontal axis title or not selecting the necessary option:
        • None to not display a horizontal axis title.
        • No Overlay to display the title below the horizontal axis.
      • Specify the Vertical axis title orientation selecting the necessary option:
        • 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.
    • The GRIDLINES section allows to specify which of the Horizontal/Vertical gridlines you wish to display selecting the necessary option: Major, Minor, or Major and Minor. You can hide the gridlines at all using the None option.

      The AXIS TITLE and GRIDLINES options will not affect Pie charts since charts of this type have no axes and gridlines.

    • 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: Center, Inner Bottom, Inner Top, Outer Top.
      • Select the data you wish to include into your labels turning on the corresponding switchers: Series Name, Category Name, Value.

    The Vertical/Horizontal Axis options will not affect Pie charts since charts of this type have no axes.

    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 Point charts, both axes are value axes.

    • The AXIS OPTIONS section allows to set the following parameters:
      • Minimum Value - is used to specify a 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 tap the Auto option and specify a different value.
      • Maximum Value - is used to specify a 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 tap the Auto option and specify a different value.
      • Axis Crosses - is used to specify a point on the vertical axis where the horizontal axis should cross it. The None 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, return to the previous screen and specify a different Crosses Value in the entry field below, or set the axes intersection point at the Minimum/Maximum Value on the vertical axis.
      • Display Units - is used to determine a 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 more compact and readable way (e.g. you can represent 50 000 as 50 by using the Thousands display units). Select desired units: 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 an opposite direction. When the switcher is turned off, the lowest value is at the bottom and the highest value is at the top of the axis. When the switcher is turned on, the values are ordered from top to bottom.
    • The TICK OPTIONS section allows to adjust 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 at the Layout tab. The Major/Minor Type menu items contain 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.
    • The LABEL OPTIONS section allows to adjust 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:
      • 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.

    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 Point charts, both axes are value axes.

    • The AXIS OPTIONS section allows to set the following parameters:
      • Axis Crosses - is used to specify a point on the horizontal axis where the vertical axis should cross it. The None 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, return to the previous screen and specify a different Crosses Value in the entry field below, 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 an opposite direction. When the switcher is turned off, categories are displayed from left to right. When the switcher is turned on, the categories are ordered from right to left.
    • The TICK OPTIONS section allows to adjust 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 at 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.
    • The LABEL OPTIONS section allows to adjust 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: 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.

    The Reorder section allows to to set the selected chart position as related to other objects when several objects overlap each other. To learn more, please refer to the Manipulate objects section of this guide.

Adjust chart appearance and text wrapping style

You can change the appearance of a chart not only from the Chart Editor window, but also from the Chart Settings panel that can be accessed from the document itself. Using this panel, you can also change the text wrapping style. To do that:

  1. Select the chart by tapping it.
  2. Open the Chart Settings panel by
    • tapping the Edit object icon at the top toolbar, or
    • tapping the Chart option in the pop-up menu.
  3. Tap the arrow next to the necessary menu item: Style, Wrap, or Reorder.

    The Style section contains the following four tabs:

    • Type - to change the current chart type (line chart, column chart, bar chart, area chart, pie chart, point chart, or stock chart). Swipe right or left to see all the chart types and tap the one you want to apply.
    • Style - to change the current chart style. Swipe right or left to see all the available styles and tap the one you want to apply.
    • Fill - to change the chart background fill by selecting a solid color, gradient template or predefined texture. Swipe right or left to see all the palettes and tap the fill you want to use.
    • Border - to adjust the chart border Size and select its Color on the palette.

    The Wrap section allows to select a text wrapping style from the available ones and adjust some additional positioning options. To learn more, please refer to the Change text wrapping section of this guide.


    The Reorder section allows to set the selected chart position as related to other objects when several objects overlap each other. To learn more, please refer to the Manipulate objects section of this guide.

Power up your iOS Create, edit and view documents, spreadsheets
and presentations of all popular formats
You Might Also Like This:
Close