What to do with Excel 2022’s new chart styles: Treemap, Sunburst, and Box & Whisker - millerantaistry

Excel 2022's many recently features include six new chart types. We'll go terminated three of them here and spill the beans about how they could be victimized with your information.

Treemap: Designed to bear witness hierarchies

Treemap has nine variations, all of which show a hierarchical view of the target data and how the sections of that hierarchy compare in size to each separate. The principal branches of the tree are displayed as rhetorical rectangles, with wedge-limbs branching out into little rectangles.

The unexcelled applications for this chart design are information with categories/groups and subcategories/subgroups. Examples would include organizational charts, product inventory; numbers pool per capita, percentages per area; budgets, sales; stamp battery, disk, or memory usage.

1. Open your spreadsheet, choice the target information, and click Insert > Inclose Hierarchy Graph > Treemap.

01 Inclose the Treemap chart.

The chart drops in and opens the Chart Tools/Design Ribbon menus. Scroll across the Purpose options and pick out one that fits your project.

02 Treemap chart Plan options

2. Suction stop the + sign to edit the Chart elements: Graph Title, Information Labels, or Legend. Past detent the paintbrush to alteration the chart's design, such as location of the fable, or font attributes.

03 Modify chart elements.

3. Right-flick any of the rectangles on the graph and select Format Data Serial publication.

04 Format Data Series on the Treemap graph.

4. In the Format Data Serial pane, click Series Options (the graph icon). Click the Serial Options down arrow and browse direct the menu choices: Chart Area, Graph Title, Information Labels, Legend, Plot Expanse, and Series. In one case you're satisfied with your changes, closely knit the panel.

05 Arrange Data Series options

Sunburst shows hierarchies and relationships

The likes of Treemap, Sunburst shows visual comparisons of relative sizes, but Sunburst also display the links between the groups and sub-groups. Each level of the power structure is delineated by one reverberate operating theatre circle with the innermost rophy at the top. This ocular delegacy provides deeper, more careful analysis capabilities, such As distinguishing the largest contributing elements within a hierarchy of numerous levels.

1. Open your spreadsheet and foreground your data. Click Insert > Insert Hierarchy Graph > Sunburst.

06 Tuck the Sunburst graph.

The chart drops in and opens the Chart Tools and Design Thread menus. Scroll across the design options and quality one that fits your cast.

07 Select the Sunburst Design options.

2. Tick the + sign to edit the Chart Elements: Title, Data Labels, or Legend. Then click the paintbrush to modify the chart's intent.

08 Select the Sunburst chart elements.

3. Right-chatter any of the rectangles on the chart and select Data formatting Data Series.

09 Sunburst Initialise Data Series

4. In the Format Information Series pane, sink in Serial Options (the chart picture). Click the Series Options downfield-pointer and browse through the menu choices: Graph Area, Chart Title, Data Labels, Caption, Plat Area, and Series. Once you're mitigated with your changes, click the X to close the panel.

010 Pick out and modify the Sunburst chart Format Data Series options.

Box & Vibrissa compares sets of information

The Package & Whisker graph (like the Histogram chart) shows the distribution of data, but this chart delves much deeper into analysis. For instance, can quickly and easy emphasize the most unique methods of information distribution much as the intend (average), quartiles, median, and percentile groupings, and it can identify outliers.

Package & Whisker is best for comparison characteristics between different sets of information, as opposed to Histogram and Pareto, which only provide visuals for matchless dataset.

1. Visible your spreadsheet and play up the target area database. Click Insert > Insert Statistical Graph > Box & Whisker. The chart appears and opens the Chart Tools/Design Ribbon menus. Scroll across the Design options and select same that fits your project.

2. Click the + sign on to edit the Graph Elements: Axes, Axes Titles, Chart Title, Data Labels, Gridlines, and/or Caption. Then mouse click the paintbrush to change the chart's blueprint.

011 Select Database and insert the Corner &adenosine monophosphate; Hair Chart.

3. Right-click any of the rectangles on the chart and select Format Information Serial.

4. In the Format Data Series pane, click Series Options (the chart picture). Penetrate the Series Options pop arrow and browse direct the menu choices. Piss the necessary changes, then click the X to immediate the panel.

12 Quality the Box & Sensory hair chart's Format Data Series.

5. Ethical-pawl the chart, then click the Pick out Data button low the Information Typewrite group.

6. The Select Data Reservoir dialogue box appears. Under Legend Entries (Series), select Series 1 (or 2, Beaver State 3, etc.), click the Edit release, then get across Satisfactory.

13 Select Data, Select Source

7. In the Edit Series dialog box, low Series Name, type the name of this serial publication group (in that suit, U.S. Market, European Market, or Eastern Grocery store). Musical note that the Series Name calling are the Markets, not the Genres (SciFi, Superhero, Fantasy).

014 Edit Series, Edit Serial Name

8. If you need to interpolate the data range for any of the serial publication, exactly enter the new range (or values) in the Series Values box.

15 Completed Box & Whisker chart.

And that's all for the new Treemap, Sunburst, and Box &adenylic acid; Whisker charts. Next up: Histogram, Pareto, and Waterfall charts.

Source: https://www.pcworld.com/article/419343/what-to-do-with-excel-2016s-new-chart-styles-treemap-sunburst-and-box-whisker.html

Posted by: millerantaistry.blogspot.com

Share this post