Quelltext der Seite The Premium Layout in Excel

[[Datei:EN_Menüband Excel Premiumlayout Gestaltung.jpg|center|1000px]]
<br>

== 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: 
*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.



{{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 ==

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.

=== Video: Application of a colour scale ===


{{Vorlage:Video-BedingteFormatierungFarbskala-English}}


=== Video: Display of arrow symbols ===


{{Vorlage:Video-BedingteFormatierungRichtungen-English}}


=== Video: The use of conditional formatting with font adaptations ===


{{Vorlage:Video-BedingteFormatierungSchriftfarbe-English}}

== See also ==
[[Datei:Navigation_hoch.svg|link=]]  [[The_Premiumlayout_in_Word|The Premiumlayout in Word]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Overview_of_the_layout_manager|Overview of the layout manager]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Settings in Word – MeetingPoint| Update Premium Layout]]

{{MoreContent}}
[[Kategorie:Word Overview of the Premium Layout]]