Advanced Excel Pie Charts - Advanced Excel Functions

How to have Pie Chart Visualizations in Power View of Advanced Excel?

Step 1 − Click on the Table Visualization as shown below.

Step 2 − Click on Other Chart in the Switch Visualization group.

Step 3 − Click on Pie as shown in the image given below.

Pie Switch Visualization Group

The Table Visualization converts into Pie Chart Visualization.

Convert Pie Chart Visualization

Now Simple Pie Chart Visualization is created wherein the count of Medals are shown by the Pie Size, and Countries by Colors. Pie Chart Visualization can also be made sophisticated by adding more features. One such example is SLICES.

Step 1 − Add Field Gender to the Table above.

Step 2 − Click on Pie Chart Visualization.

Step 3 − Drag Field Gender in the Power View Fields List to the SLICES Box as shown below.

Slices Box

Now, with SLICES, the count of Medals for men and for women in each country can be visualized.

Step 4 − Click on a SLICE in the Pie Chart Visualization.

Step 5 − Only the specific row containing the data specific to the SLICE will be displayed in the TABLE VISUALIZATION above.

Selected Slices

How to use Bubble and Scatter Charts in Advanced Excel?

Bubble and Scatter charts can be used to display many related data in one chart. In Scatter charts, the x-axis displays one numeric field and the y-axis displays another, making it easy to see the relationship between the two values for all the items in the chart. In a Bubble Chart, a third numeric field controls the size of the data points.

Step 1 − Add one Category Field and one Numeric Field to the Table.

Step 2 − Click on Other Chart in the Switch Visualization group.

Step 3 − Click on Scatter.

Scatter Charts

The Table Visualization converts into Scatter Chart Visualization. The Data points are little circles and all are of same size and same color. Category is in DETAILS Box.

Scatter Charts Visualization

Step 4 − Drag Medal to Size.

Step 5 − Drag field NOC_CountryRegion to Σ X VALUE.

The Scatter Chart Visualization converts into Bubble Chart Visualization. The data points are circles of the size represented by the values of Data points. The color of the circles is the X VALUE and given in the Legend. The data labels are the Category Values.

Bubble Chart Visualization

Step 6 − Drag the field NOC_CountryRegion to the COLOR Box. The bubbles will be coloured by the values of the field in the COLOR box.

Step 7 − Drag the Year field to PLAY AXIS. A Time Line with Play button will be displayed below the Bubble Chart Visualization.

Colour Play Axis

Step 8 − Click on the Play button. The bubbles travel, grow, and shrink to show how the values change based on the PLAY AXIS. Pause at any point to study the data in more detail.

Colour Play Axis

Step 9 − Click any colour on the Legend. All the bubbles of that colour will be highlighted and other bubbles will be grayed out.

Legend Colour Selected

How to use Maps in Advanced Excel?

Maps are used to display the data in the context of geography. Maps in Power View use Bing map tiles, so that it can be zoomed and pan as with any other Bing map. To make maps work, Power View has to send the data to Bing through a secured web connection for geocoding. So, it asks to enable the content. Adding locations and fields places dots on the map. The larger the value, the bigger the dot. When a multivalue series is added, pie charts on the map appear, with the size of the pie chart showing the size of the total.

Step 1 − Drag a Geographic Field such as Country/Region, State/Province, or City from Power View Fields List to the table.

Step 2 − Drag a numeric field such as Count to the table.

Geographic Field

Step 3 − Click on DESIGN tab on the ribbon.

Step 4 − Click on Map in the Switch Visualization group.

Map Switch Visualization

The Table Visualization converts into Map Visualization. Power View creates a map with a dot for every geographic location. The size of the dot is the value of the corresponding numeric field.

Step 5 − Click on a dot. The data, viz., the geographic location and the numeric information relating to the size of the dot will be displayed.

Map Visualization

Step 6 − Verify that below the Power View Fields List, the Geographic field is in the Locations Box and Numeric Field is in the Σ SIZE Box.

Step 7 − Drag Medal to COLOR Box. The Dots are converted into Pie Charts. Each Color in the Pie representing the category of the Medals.

Step 8 − Place the cursor on one of the Dots. The Dot gets highlighted and zoomed. The details of the Pie Slice are displayed.

Pie Highlighted Zoomed

Step 9 − Place the cursor on one of the Dots and click on it. That Pie Slice is highlighted. The other Slices in the Pie and all other Pie Dots will gray out.

Other Pie Dots

What are Multiples in Advanced Excel?

Multiples are a series of charts with identical X and Y axes. Multiples can be arranged side by side, making it easy to compare many different values at the same time. Multiples are also called Trellis Charts.

Step 1 − Start with a Pie Chart. Click on the Pie Chart.

Step 2 − Drag a Field to Vertical Multiples.

Step 3 − Click on the LAYOUT tab on the ribbon.

Step 4 − Click on Grid Height and select a number.

Step 5 − Click on Grid Width and select a number.

Vertical Multiples expand across the available page width and then wrap down the page into the space available. If all the multiples do not fit in the available space, you get a vertical scroll bar.

Vertical Multiples

Step 6 − Drag the field in VERTICAL MULTIPLES to HORIZONTAL MULTIPLES. The horizontal multiples expand across the page. If all the multiples do not fit in the page width, you get a horizontal scroll bar.

Vertical Horizontal Multiples

Step 7 − Click on Multiples.

Step 8 − Click on the DESIGN tab on the ribbon.

Step 9 − Click on Other Chart in the Switch Visualization group.

Step 10 − Click on Line. The Horizontal Multiples of the Line charts are created.

Horizontal Scroll Bar

Step 11 − Drag the Field in HORIZONTAL MULTIPLES to VERTICAL MULTIPLES. VERTICAL MULTIPLES of Line Charts are created.

Vertical Multiples Line

What are Visualization Tiles in Advanced Excel?

Tiles are containers with a dynamic navigation strip. A Table, Matrix or Chart can be converted to Tiles to present data interactively. Tiles filter the content inside the Tile to the value selected in the Tab Strip. A single Tile can be made available for each possible field value so that if clicked on that Tile, data specific to that Field is displayed.

Step 1 − Drag the Field desired to use as your Tile from the Fields List and drop it in the Tile by box. The Tile Navigation Strip displays the Values for that Field.

Step 2 − Click the Tiles to move between the data for different Tiles. The data changes in the Stacked Bar Chart Visualization according to the selected Tile. All the content in the container is filtered by the selected Tile value.

Selected Tile

The Tile container has two navigation strip types: tile flow and tab strip.

The above created is the tab strip. Tab strip displays the navigation strip across the top of the visualization.

Step 3 − Click on a Tile.

Step 4 − Click on the DESIGN tab on the ribbon.

Step 5 − Click on Tile Type in the Tiles group.

Step 6 − Click on Tile Flow.

Tile Flow

The Tile flow displays the navigation strip across the bottom of the Visualization. The selected Tile is always centered.

Tile Flow Navigation

Click on the Tiles or Scroll through the Tiles by using the Scroll Bar. When you Scroll, the Tiles go on being selected.

Step 7 − Click on Map in the Switch Visualization group.

Step 8 − Drag Medal to Color.

Step 9 − De-select the Field Gender

Selected Tile Connect

Map Visualization with Tile Flow is created.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

Advanced Excel Functions Topics