The Premium Layout in Excel: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(16 dazwischenliegende Versionen von einem anderen Benutzer werden nicht angezeigt)
Zeile 1: Zeile 1:
[[Datei:EN_Menüband Excel Premiumlayout Gestaltung.jpg|center|1500px]]
[[Datei:EN_Menüband Excel Premiumlayout Gestaltung.jpg|center|1000px]]
<br>


== Adjust graphics ==
== Adjust Charts==
To simplify the transfer of graphics from Excel to Word, there is the "Adjust graphic" function. Using this function, it is possible to adapt graphics to the table widths or type area in your Word document in Excel. This saves you work when finalising your Word document later. At the touch of a button, you select the appropriate width and the proportionally appropriate height is determined automatically.  
To simplify the transfer of chart from Excel to Word, there is the "Adjust chart width" function. Using this function, it is possible to adapt charts to the table widths or type area in your Word document in Excel. This saves you work when finalising your Word document later. At the touch of a button, you select the appropriate width.  




If you are unsure which graphic width you should select, you have two possible orientation options:  
If you are unsure which chart width you should select, you have two possible orientation options:  
*You can display which type area your document has in the [[The_firesys_video_zone#Page_layout| Layout functions]].
*You can display which type area your document has in the [[The_firesys_video_zone#Page_layout| Layout functions]].
*You can check in [[The_table_assistant | Table assistant]] in Word which width you have selected here for tables.
*You can check in [[The_table_assistant | Table assistant]] in Word which width you have selected here for tables.


<p align="left">To adjust the width of a graphic, proceed as follows:  <br>
<ol>
  <li> <p align="left">Click on the graphic you want to adjust. </li>
  <li> <p align="left">Click on the " Adjust graphic" button in the "Design" group on the "*Premium Layout" tab. <br> &rarr; A dialogue opens in which you can choose between different settings for the graphic.</li> 
  <li> <p align="left">Click on the settings you want for your graphic. <br> &rarr; The selected settings are applied to the graphic. The graphic settings are applied when transferring from Excel to Word.</li> 
</ol>


{{Vorlage:EN_Video-Premiumlayout_GrafikbreitenAnpassen}}
== Chart templates ==
firesys provides you with a range of chart templates that you can insert at the touch of a button. You have the choice between
*Column chart (This chart type allows you to visually compare values between categories).
*Line chart (With this chart type, you can display trends over a period of time (years, months or days) or for categories).
*Bar chart (This chart type allows you to visually compare values between categories).
*Pie chart (With this chart type, you can display proportions of a whole. This chart type can be used when the sum of the values is 100%).
*Combo Chart (Use this chart type to highlight different types of information. Use it when the range of values in the chart veries widely or you have mixed types of data)
*Scatter Chart (Use this chart type to show the relationship between sets of values)
{{Vorlage:Video-EN_Daigrammvorlage_einfügen}}


== [[Datei:ConditionalFormattingMenu_16.png|link=|16px]] Conditional formatting ==
== [[Datei:ConditionalFormattingMenu_16.png|link=|16px]] Conditional formatting ==


Find trends and patterns in your data easily with the aid of bars. Colours and symbols visually highlight important values. The conditional formatting can be transferred to Word.  
Find trends and patterns in your data easily with the aid of bars. Colours and symbols visually highlight important values. The conditional formatting can be transferred to Word.  
[[Datei:EN Bedingte Formatierung Excel Word.jpg|thumb|center|The transfer of the various format styles from Excel to Word is shown here.|750px]]
<div style="margin:0px; padding:0.7em 1em 0.7em 1em; background-color:#f6f4f2;border:1px solid #e67d05">
{|
|-
! rowspan="2" |[[Datei:Glühbirne neu.png|left|link=|center|24px|]]
!<div style="text-align:left; font-size:120%;">Good to know</div>
|-
|<div style="font-size:95%;text-align:left;margin-top:10px;">
firesys supports the Format Styles "2-Color Scale", "3-Color Scale" and "Icon Sets". The "Data Bar" format style is not supported by firesys.
|}
</div>
</div>


The transfer of the background and font colours of an Excel cell is available to you in all firesys documents. The relevant option must be activated in Word for the transfer. In the firesys layout, you can also integrate icon sets in tables.
The transfer of the background and font colours of an Excel cell is available to you in all firesys documents. The relevant option must be activated in Word for the transfer. In the firesys layout, you can also integrate icon sets in tables.

Aktuelle Version vom 8. Mai 2024, 12:42 Uhr

EN Menüband Excel Premiumlayout Gestaltung.jpg


Adjust Charts

To simplify the transfer of chart from Excel to Word, there is the "Adjust chart width" function. Using this function, it is possible to adapt charts to the table widths or type area in your Word document in Excel. This saves you work when finalising your Word document later. At the touch of a button, you select the appropriate width.


If you are unsure which chart width you should select, you have two possible orientation options:



A detailed explanation of the individual steps

To adjust the width of a chart, proceed as follows:

  1. Click on the chart you want to adjust.

  2. Click on the " Adjust chart width" button in the "Graphics" group on the "*Premium Layout" tab.
    → A dialogue opens in which you can choose between different settings for the chart. /li>

  3. Click on the settings you want for your chart.
    → The selected settings are applied to the graphic. The chart settings are applied when transferring from Excel to Word.


Chart templates

firesys provides you with a range of chart templates that you can insert at the touch of a button. You have the choice between

  • Column chart (This chart type allows you to visually compare values between categories).
  • Line chart (With this chart type, you can display trends over a period of time (years, months or days) or for categories).
  • Bar chart (This chart type allows you to visually compare values between categories).
  • Pie chart (With this chart type, you can display proportions of a whole. This chart type can be used when the sum of the values is 100%).
  • Combo Chart (Use this chart type to highlight different types of information. Use it when the range of values in the chart veries widely or you have mixed types of data)
  • Scatter Chart (Use this chart type to show the relationship between sets of values)



A detailed explanation of the individual steps

To insert one of the templates, proceed as follows:

  1. In your table, select the data you want to display.

  2. Click on the "Columns"/"Bars"/"Lines"/"Pie" button in the "Graphics" group on the "*Premium Layout" ribbon.
    → The chart is inserted.


ConditionalFormattingMenu 16.png Conditional formatting

Find trends and patterns in your data easily with the aid of bars. Colours and symbols visually highlight important values. The conditional formatting can be transferred to Word.

The transfer of the various format styles from Excel to Word is shown here.


Glühbirne neu.png
Good to know

firesys supports the Format Styles "2-Color Scale", "3-Color Scale" and "Icon Sets". The "Data Bar" format style is not supported by firesys.


The transfer of the background and font colours of an Excel cell is available to you in all firesys documents. The relevant option must be activated in Word for the transfer. In the firesys layout, you can also integrate icon sets in tables.

Video: Application of a colour scale


A detailed explanation of the individual steps

To assign a colored conditional formatting to table cells:

  1. Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.

  2. Click on the "Conditional Formatting" button in the "*Premium Layout" ribbon.

  3. Select the "Color Scales" submenu from the drop-down menu - and select the desired color scale.
    → The selected cells are now highlighted, depending on the selected formatting scale.


Video: Display of arrow symbols


A detailed explanation of the individual steps

To assign a colored conditional formatting to table cells:

  1. Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.

  2. Click on the "Conditional Formatting" button in the "Design" ribbon.

  3. Select the "Directions" submenu from the drop-down menu - and select the desired arrow constellation.
    → The selected cells are now provided with colored arrows, depending on the selected formatting direction.

  4. Switch to the Word document in which the linked table was included.

  5. Open the firesys settings and check that the function "Set highlighting" is selected in the group "Table layout and structure" in the tab "Data from Excel".

  6. Select the desired table - and execute the function "Update selected object" in the menu band "Contents" in the group "Excel data".
    → The table is now updated and the corresponding conditional formatting with is applied to the table.


Video: The use of conditional formatting with font adaptations


A detailed explanation of the individual steps

To assign a colored conditional formatting to table cells:

  1. Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.

  2. Click on the "Conditional Formatting" button in the "Design" ribbon.

  3. Select the "Cell highlighting rules" submenu from the drop-down menu - and select the desired criterion.
    → A dialog opens where you can specify the behavior of the conditional formatting more precisely.

  4. Select the "custom format" option in the right-hand selection dialog.

  5. In the dialog that now opens, select the desired font to be used when the conditional formatting is displayed.

  6. Save the Excel document and switch to Word.

  7. Make sure that the setting "Font color" is activated in the group "Data from Excel" in the submenu "Table design and structure" in the firesys settings.

  8. Execute the "Update" function in the "Excel Data" group in the "*Contents" menu band.
    → The table is updated and the conditional formatting is applied to the table.

  9. .

See also

Navigation hoch.svg The Premiumlayout in Word
Navigation rechts.svg Overview of the layout manager
Navigation rechts.svg Update Premium Layout

Further contents

firesys website
Customer area
YouTube