Advanced Microsoft Excel
Part 19 - Pie Charts
You can have simple Pie Chart Visualizations in Power View.
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.


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.

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.

Bubble and Scatter Charts
You can use the Bubble and Scatter charts 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.


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.

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



Maps
You can use Maps to display your data in the context of geography. Maps in Power View use Bing map tiles, so you can zoom and pan as you would 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 you to enable the content. Adding locations and fields places dots on the map. The larger the value, the bigger the dot. When you add a multivalue series, you get pie charts on the map, 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.

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

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.

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.


Multiples: A Set of Charts with the Same Axes
Multiples are a series of charts with identical X and Y axes. You can have Multiples 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.


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. You have created Horizontal Multiples of the Line charts.


Visualization – Tiles
Tiles are containers with a dynamic navigation strip. You can convert a Table, Matrix or Chart to Tiles to present data interactively. Tiles filter the content inside the Tile to the value selected in the Tab Strip. You can have a single Tile for each possible field value so that if you click on that Tile, data specific to that Field is displayed.Step 1 − Drag the Field you want 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.

What you have created above 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.


Step 7 − Click on Map in the Switch Visualization group.
Step 8 − Drag Medal to Color.
Step 9 − De-select the Field Gender

No comments:
Post a Comment