Create a treemap chart in Office - Microsoft Support
Use the Treemap chart, introduced in Office 2016 for Windows to quickly see a hierarchial representation of your data. Treemap charts are often used to quickly identify patterns in lots of data points.
Create a tree diagram - Microsoft Support
Drag the control handles on the tree shapes to create more branches or to change the branch length or position.. 1 Drag the control handle on the trunk to the right to create more branches.. 2 Drag the control handle at the end of a branch horizontally or vertically to change its position.
Create a waterfall chart - Microsoft Support
Use the waterfall chart to quickly see positive and negative values impacting a subtotal or total value. Waterfall charts are often used to visualize financial statements, and are sometimes called bridge charts.
Available chart types in Office - Microsoft Support
The treemap chart provides a hierarchical view of your data and an easy way to compare different levels of categorization. The treemap chart displays categories by color and proximity and can easily show lots of data which would be difficult with other chart types.
Format a Map Chart - Microsoft Support
Following are some guidelines for formatting a Map chart's Series Options. To display the Series Options for your map chart you can right-click on the outer portion of the map and select Format Chart Area in the right-click menu, or double-click on the outer portion of the map.
Create a histogram - Microsoft Support
How to create a histogram chart in Excel that shows frequency generated from two types of data (data to analyze and data that represents intervals to measure frequency).
Create a sunburst chart in Office - Microsoft Support
The sunburst chart is most effective at showing how one ring is broken into its contributing pieces, while another type of hierarchical chart, the treemap chart, is ideal for comparing relative sizes.
Create a PivotChart - Microsoft Support
For example, treemap charts, statistical charts, and combo charts do not work with PivotTables yet. After you insert a column, line, pie, or radar chart, you can pivot it by changing or moving fields using the PivotTable Fields list .
Create a Pareto chart - Microsoft Support
Create a Pareto chart. Select your data. Typically, you select a column containing text (categories) and one of numbers. A Pareto chart then groups the same categories and sums the corresponding numbers.
Erstellen eines Treemap-Diagramms in Office - Microsoft-Support
Ein Treemap-Diagramm bietet eine hierarchische Ansicht Ihrer Daten und erleichtert es, Muster zu erkennen, z. B. welche Elemente die Bestseller eines Stores sind. Die Verzweigungen werden durch Rechtecke dargestellt, und jede untergeordnete Verzweigung wird als kleineres Rechteck wiedergegeben.