Edit Data Chart Properties

Available from Version: - 

Operating System: Windows 

empower® Add-in: Charts

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 Mekko or line charts you can add more axes than for bar and waterfall charts.

Figure 1. Button Properties

Button Properties

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.

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.

Figure 3. Bar Width Setting

Bar Width Setting

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%.

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 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 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 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 make global changes to you charts regarding font size, scale and size, choose the option Apply to All empower Charts on Slide (Figure 20, “Apply Global Changes”).

Figure 20. Apply Global Changes

Apply Global Changes

Here, you can decide if you want to apply the current font size to all charts on the current slide (Figure 21, “Options for Global Changes”).

In addition, you can apply the scale and size for axes to all charts on the current slide (Figure 21, “Options for Global Changes”).

This function can be helpful to match charts that have breaks.

The matching to height orientates itself to the highest chart on the slide.

If possible, always apply the same scale and size to the chart which has the smallest scale, i.e. where a certain reference value (e.g. 100) is displayed the smallest.

Figure 21. Options for Global Changes

Options for Global Changes

Note

The available options depend on the chart type in use.

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

A dialog box opens.

Figure 22. Option Change Customizing

Option Change Customizing

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

Then, click on the button OK.

Figure 23. Choose Customizing

Choose Customizing

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

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

Display issues should then be corrected automatically.

Figure 24. 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 been applied manually on data points to go back to the default customizing colors, choose the option Reset Point Colors and Borders (Figure 25, “Reset Point Formatting”).

For some charts, you can only reset the borders.

Figure 25. Reset Point Formatting

Reset Point Formatting

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.

Note

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

Was this article helpful?

/

Comments

0 comments

Article is closed for comments.