Edit diagrams

Adapt diagrams to your corporate design. You have the possibility to design your diagrams individually. These include, among other things, axis and Data captions as well as the colouring of the individual diagram elements.

Functions

In order to take advantage of the Layout manager when designing graphics, you need to consider a few points when creating graphics in Excel.
The Layout manager accesses a specific colour palette in Excel and converts these colours into the colours you selected in the Layout manager in Word. The advantage is that you do not have to worry about the layout in Excel. If you initially create a graphic in Excel, Excel will automatically use the colour palette accessed by the Layout manager. When transferring to Word, the accents 1 - 6 in Excel are replaced with the colours 1 - 6 in the Layout manager. Your graphic will therefore probably have different colours in Excel than later in Word.

If you want your graphics and diagrams to be displayed in Excel in the same way as they will be converted later in Word, you must adapt the selected colours in the Layout manager to the accents in Excel. You have two options:

• You can adjust the accents in Excel to align them with the Layout manager
• You can adapt the colours in the Layout manager to the selected colours in Excel

Adapt diagrams

You can customise your charts with the following parameters. Axis and data caption
Here, both font colour and font type can be adapted to your individual wishes.

Colour of the individual data types
Select a colour for the individual data types (previous year, current year, forecast, budget, positive/negative development are only suggestions and do not have to match your graphic). You can define colours for a total of six data types.

Related elements are displayed in the “Edit Diagrams” dialogue when you hold the mouse pointer over the corresponding element. Clicking on the respective element opens an editing dialogue where you can choose between a variety of colours. When selecting colours, you have the option of either defining a custom colour using RGB values or selecting a colour from the Office colour palette.

In the Layout manager, click on the arrow symbol next to Diagram to display all diagram elements in the list. If you select one of the list elements and then click on Edit, the position of the corresponding element is marked by a red arrow.

Video: Edit diagrams

The explanation of the individual steps in detail

This is how you design your diagrams in the corporate design:

1. Click on the “Layout manager“ button in the “*Premium Layout” tab in the “Premium Layout” group.
   → The Layout manager opens.

2. In the Layout manager, select the colour scheme you want to adjust and click on the arrow symbol on the left.

3. Click on “Diagrams” underneath.
   → In the group “Diagrams” the “Edit” button is now selectable.

4. Click on the “Edit” button.
   → The editing window opens.

5. Select the elements you want to adjust.

6. The following things can be changed individually:

   1. Font and colour of the axis labelling

   2. Font and colour of the data caption

   3. Colour of the individual data types (previous year, current year, forecast, budget)

   4. Colour of the individual arrows (Positive development and Negative development)

   Note: you can set custom colours via the RGB values as well as select them via the Office colour palette. Switch between these two options with the “User-defined colour” button in the lower left corner.

7. Click on "OK" to confirm your settings.
   → The settings made are transferred to the Layout manager. To apply the changes to the document, the layout must be applied (see Apply Colour scheme).

Adjusting accents in Excel

To match the accents (=colours) in Excel to the colours in the Layout manager, proceed as follows:

1. Click on "Colours" in the "Page layout" tab in the "Design" group.
   → A drop-down menu opens, displaying various colour options.

2. Click on "Customise colours".
   → The window "Create new design colours" opens./li>

3. Adjust the accents 1 - 6. The Layout manager accesses these when converting the colours.

4. Assign a name.

5. Click on "Save".
   → The colours you choose are automatically applied to your chart in Excel. If the accents 1 - 6 correspond to the selected colours 1 - 6 in the Layout manager, the colours of the chart in Excel will correspond to those in Word.

See also

Overview of the Premium Layout
Other functions
Edit texts
Edit tables

Further contents

→ firesys website
→ Customer area
→ YouTube