Edit Data Chart Properties

Available from Version: - 

Operating System: Windows 

empower® Add-in: Chart Creation

Under the button Properties in the action bar, you can make further changes to your data chart (Figure 1, “Button Properties”).

The available options depend on the chart type in use. For example, line chart properties include additional options for lines, and for Mekko or line charts you can add more axes than for bar and waterfall charts.

Here, you can edit the default settings for the data chart and decide which axes you want to display. In addition, you can enable and disable a chart title and the chart legend.

For all data chart types, you have the option to apply global changes to all charts on the current slide, to change the customizing, redraw the chart and to enable manual edit mode.

Figure 1. Button Properties

Button Properties

In the first section, you can set the chart text's font size and the bar width, if there are bars in your chart.

To define a new font size, enter a value into the input field under Font Size (Figure 2, “Font Size Setting”).

Alternatively, expand the drop-down menu or use the buttons next to the input field to increase or decrease the value.

Figure 2. Font Size Setting

Font Size Setting

To set a new bar width, type in a percentage into the input field under Bar Width (%) (Figure 3, “Bar Width Setting”).

Alternatively, use the little arrow symbols next to the input field or use the slider to increase or decrease the value.

If you set the bar width to 100%, the bars will be located right next to each other without any space between them.

The lowest value you can use is 10%.

Figure 3. Bar Width Setting

Bar Width Setting

For some chart types such as circle charts, you can define the chart size instead of the bar size (Figure 4, “Chart Size Setting”).

To edit the chart size, type in a percentage into the input field.

Alternatively, use the little arrow symbols next to the input field or use the slider to increase or decrease the value.

Figure 4. Chart Size Setting

Chart Size Setting

In doughnut charts, you can also set the doughnut width (Figure 5, “Doughnut Width Setting”).

To edit the doughnut width, type in a percentage into the input field.

Alternatively, use the little arrow symbols next to the input field or use the slider to increase or decrease the value.

Figure 5. Doughnut Width Setting

Doughnut Width Setting

Note

Due to technical limitations in PowerPoint, the percentage refers to the doughnut hole in the middle of the chart.

During the calculation, the values are therefore rounded.

If your entered value is rounded up, you can enter a lower value to achieve your preferred result.

Edit Legend, Axes and Title Properties

For most chart types, you can enable or disable the legend and axes. In addition, you can decide if you want to display a chart title or not.

To enable a legend, choose the option Show Legend (Figure 6, “Legend Options”).

Then, choose where you want to display the legend. Here, you have several options.

To disable the legend completely, choose the option None.

Figure 6. Legend Options

Legend Options

To display a vertical axis for the value, choose the option Vertical Axis (Value) and then switch the toggle button for Show Value Axis to On (Figure 7, “Enable And Reverse Vertical Axis” (1)).

To reverse the axis direction and place the horizontal axis above the chart instead of underneath, switch the toggle button for Reverse Axis Direction to On (Figure 7, “Enable And Reverse Vertical Axis” (2)).

You can also use this option if you have not enabled the vertical axis but the horizontal axis.

Figure 7. Enable And Reverse Vertical Axis

Enable And Reverse Vertical Axis

If you have enabled the vertical axis, you can make further changes to the axis.

You can set the number format, scale and text format.

To set the number format, expand the drop-down menu under Number Format and choose a format (Figure 8, “Number Format”).

To define your own custom format, choose the option Custom Number Format.

A dialog box opens.

Figure 8. Number Format

Number Format

In this dialog box, either choose a format from the list or type in a custom format you want to use (Figure 9, “Custom Number Format”).

A preview is displayed above the input field.

If you have finished, click on the button OK.

Figure 9. Custom Number Format

Custom Number Format

To set a scale, expand the drop-down menu under Scale and choose a value (Figure 10, “Scale”).

Figure 10. Scale

Scale

To set a text format, expand the drop-down menu under Text Format and choose a format (Figure 11, “Text Format”).

To define your own text format, choose the option Custom….

Figure 11. Text Format

Text Format

Note

For further information regarding custom text formats for labels, see Custom Labels.

You can define the minimum and maximum value displayed on the axis. In addition, you define how big the steps between each displayed value should be (Figure 12, “Define Values And Step Size”).

Values are already entered automatically.

To change them, type in a new value into the input field.

To go back to the automatic value, click on the button Reset next to the input field.

Figure 12. Define Values And Step Size

Define Values And Step Size

For some chart types, you have the option to enable a second vertical axis. This axis is then inserted on the right of the chart and also displays the values.

To enable this axis, choose the option Secondary Vertical Axis (Value) (Figure 13, “Enable Secondary Vertical Axis”) and then switch the toggle button for Show Value Axis to On.

Figure 13. Enable Secondary Vertical Axis

Enable Secondary Vertical Axis

To enable the horizontal axis for the categories, switch the toggle button for Horizontal Axis (Category) to On (Figure 14, “Enable Horizontal Axis for Category”).

The axis labels display the text that is added in the mini Excel.

Figure 14. Enable Horizontal Axis for Category

Enable Horizontal Axis for Category

For some chart types, you have the option to enable a second horizontal axis. This horizontal axis will then be used as a second value axis.

To enable the horizontal axis for values, switch the toggle button for Horizontal Value Axis to On (Figure 15, “Enable Horizontal Axis for Value”).

For some chart types such as bar charts, you have the same options for the horizontal value axis as for the vertical value axis.

Figure 15. Enable Horizontal Axis for Value

Enable Horizontal Axis for Value

Note

For further information regarding the mini Excel for data charts, see Mini Excel for Data Charts.

If you want to display a chart title, switch the toggle button for Show Chart Title to On (Figure 16, “Enable Chart Title”).

The title will be displayed and you can edit the title text as required.

If you enable and disable the chart title again, your changes to the title text will be lost.

Figure 16. Enable Chart Title

Enable Chart Title

To remove the chart title, you can also select it and click on the button Remove (Figure 17, “Button Remove”).

Figure 17. Button Remove

Button Remove

Note

For circle chart types only the legend and title options are available.

Edit Line Settings

For line charts, you have additional options.

To open these settings, choose the option Line Settings (Figure 18, “Line Settings”).

Figure 18. Line Settings

Line Settings

To interpolate missing values, switch the toggle button for Interpolate Missing Values to On (Figure 19, “Line Settings Options”).

To use a smooth line, switch the toggle button for Smooth Line to On (Figure 19, “Line Settings Options”).

The line will change to be displayed smoothly, without sharp edges.

To use markers, switch the toggle button for Markers to On (Figure 19, “Line Settings Options”).

If you disable this setting, the dots and the line which mark the data points will be removed.

Figure 19. Line Settings Options

Line Settings Options

Edit General Chart Properties

In the last section of the properties menu, you can make general changes.

To apply the preferred category and bar width that you have defined in your user settings to the chart, choose the option Apply Preferred Category and Bar Width (Figure 20, “Preferred Category and Bar Width”).

The values from your user settings are automatically applied to the chart.

Figure 20. Preferred Category and Bar Width

Preferred Category and Bar Width

Important

If you apply your preferred category and bar width to the chart, the size of the chart may change.

Note

For further information regarding the preferred bar and category width, see User Settings.

To apply the properties and settings of the currently selected chart to other empower® Charts on your slide or in your presentation, choose the option Apply Properties to Other Charts (Figure 21, “Apply Properties to Other Charts”).

A dialog box opens.

Figure 21. Apply Properties to Other Charts

Apply Properties to Other Charts

In this dialog box, you can choose which properties you want to transfer to the other data charts (Figure 22, “Select Properties to Transfer to Other Charts”).

You can transfer properties from the following categories:

  • Labels

  • Colors

  • Axes

  • Alignments

  • Bar and Category Width

Figure 22. Select Properties to Transfer to Other Charts

Select Properties to Transfer to Other Charts

To display further information regarding the options, hover over the information symbols.

To select one of the properties, tick the checkbox for the respective option.

Under Alignment and Bar and Category Width, only one option can be selected.

Then, click on the button Start Format Painter Mode.

Then, go through your presentation and click on the charts that you want to transfer the properties of the source chart to.

The selected properties from the source chart will be applied to the data charts you click on.

When you have finished, press ESC to exit the format painter mode.

Note

Some properties cannot be transferred to other charts, e.g. due to the data structure of different chart types or the availability of properties across chart types.

If one of the selected properties from the source chart cannot be transferred to one of the selected target charts, or if the respective property has already been applied on the target chart, this property is skipped but all applicable properties are transferred.

If you only want to transfer the properties and settings from one chart on your current slide to other charts on your current slide, follow the following steps:

  1. Select all charts to which you want to transfer the properties.

    To do so, press Ctrl and then select all charts.

  2. Then, press Ctrl and select the chart whose properties you want to transfer.

    A settings symbol appears in the upper right corner of the chart (Figure 23, “Settings Symbol”).

  3. Click on the settings symbol.

    A dialog box opens.

    Here, you have the same options as mentioned above.

Figure 23. Settings Symbol

Settings Symbol

  1. In this dialog box, select all properties that you want to transfer (Figure 24, “Select Properties to Transfer to Selected Charts”).

  2. Then, click on the button Apply.

Figure 24. Select Properties to Transfer to Selected Charts

Select Properties to Transfer to Selected Charts

Note

If an option is not displayed, it is currently not available.

If there are multiple customizings for your company, you can switch between the customizings. To do so, choose the option Change Customizing (Figure 25, “Option Change Customizing”).

A dialog box opens.

Figure 25. Option Change Customizing

Option Change Customizing

Expand the drop-down menu and choose the customizing you want to use for this chart (Figure 26, “Choose Customizing”).

Then, click on the button OK.

If there is only one customizing for your company, the option Change Customizing is grayed out.

Figure 26. Choose Customizing

Choose Customizing

If you encounter any display issues in the chart, you can use the option Redraw Chart to reload the chart and its content (Figure 27, “Option Redraw Chart”).

Display issues should then be corrected automatically.

Figure 27. Option Redraw Chart

Option Redraw Chart

Note

Alternatively, you can change the customizing for the whole presentation. To do so, click on the button More in the group empower and then choose the option Change Customizing for Presentation. A dialog box opens and you can choose a customizing.

Note

For further information regarding the switch of the default customizing, see User Settings.

To reset colors and borders that you have applied manually on data points to go back to the default customizing colors, choose the option Reset Point Colors and Borders (Figure 28, “Reset Point Formatting”).

For some charts, you can only reset the borders.

In addition to the settings mentioned above, you can enter the manual edit mode.

Manual edit mode should only be entered if you want to make final changes that cannot be made to an empower® Chart. In manual edit mode, you can edit the chart and its components freely.

If you use manual edit mode and then leave it again, some formatting you have made in manual edit mode may be lost.

Figure 28. Reset Point Formatting

Reset Point Formatting

Note

For further information regarding manual edit mode, see Manual Edit Mode.

Was this article helpful?

/

Comments

0 comments

Article is closed for comments.