Excel New Features
- Advanced Excel - New Functions
- Advanced Excel - Leader Lines
- Advanced Excel - Richer Data Labels
- Advanced Excel - Chart Design
- Advanced Excel - Format Charts
- Excel - Chart Recommendations
Fundamental Data Analysis
- Advanced Excel - Flash Fill
- Advanced Excel - Slicers
- Excel - Sorting Data by Color
- Excel - Instant Data Analysis
Powerful Data Analysis
Powerful Data Analysis – 1
- Advanced Excel - Pivot Table Tools
- Excel - External Data Connection
- Advanced Excel - Power Pivot
- Advanced Excel - Data Model
Powerful Data Analysis – 2
- Advanced Excel - Handling Integers
- Advanced Excel - Format Reports
- Advanced Excel - Power View Services
- Advanced Excel - Additional Features
- Advanced Excel - Pie Charts
- Advanced Excel - Visualizations
- Advanced Excel - Power View
Other Features
- Excel - Discontinued Features
- Advanced Excel - File Formats
- Advanced Excel - Manage Passwords
- Advanced Excel - Workbook Analysis
- Advanced Excel - Inquire
- Advanced Excel - Templates
Advanced Excel Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Advanced Excel - Pie Charts
You can have simple Pie Chart Visuapzations in Power View.
Step 1 − Cpck on the Table Visuapzation as shown below.
Step 2 − Cpck on Other Chart in the Switch Visuapzation group.
Step 3 − Cpck on Pie as shown in the image given below.
The Table Visuapzation converts into Pie Chart Visuapzation.
You now have a Simple Pie Chart Visuapzation wherein the count of Medals are shown by the Pie Size, and Countries by Colors. You can also make your Pie Chart Visuapzation sophisticated by adding more features. One such example is SLICES.
Step 1 − Add Field Gender to the Table above.
Step 2 − Cpck on Pie Chart Visuapzation.
Step 3 − Drag Field Gender in the Power View Fields List to the SLICES Box as shown below.
Now, with SLICES, you can visuapze the count of Medals for men and for women in each country.
Step 4 − Cpck on a SLICE in the Pie Chart Visuapzation.
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 − Cpck on Other Chart in the Switch Visuapzation group.
Step 3 − Cpck on Scatter.
The Table Visuapzation converts into Scatter Chart Visuapzation. The Data points are pttle circles and all are of same size and same color. Category is in DETAILS Box.
Step 4 − Drag Medal to Size.
Step 5 − Drag field NOC_CountryRegion to Σ X VALUE.
The Scatter Chart Visuapzation converts into Bubble Chart Visuapzation. 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 6 − Drag the field NOC_CountryRegion to the COLOR Box. The bubbles will be colored 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 Visuapzation.
Step 8 − Cpck on the Play button. The bubbles travel, grow, and shrink to show how the values change based on the PLAY AXIS. You can pause at any point to study the data in more detail.
Step 9 − Cpck any color on the Legend. All the bubbles of that color will be highpghted and other bubbles will be grayed out.
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 3 − Cpck on DESIGN tab on the ribbon.
Step 4 − Cpck on Map in the Switch Visuapzation group.
The Table Visuapzation converts into Map Visuapzation. 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 − Cpck on a dot. The data, viz., the geographic location and the numeric information relating to the size of the dot will be displayed.
Step 6 − You can also 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 highpghted and zoomed. The details of the Pie Spce are displayed.
Step 9 − Place the cursor on one of the Dots and cpck on it. That Pie Spce is highpghted. The other Spces in the Pie and all other Pie Dots will gray out.
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 Trelps Charts.
Step 1 − Start with a Pie Chart. Cpck on the Pie Chart.
Step 2 − Drag a Field to Vertical Multiples.
Step 3 − Cpck on the LAYOUT tab on the ribbon.
Step 4 − Cpck on Grid Height and select a number.
Step 5 − Cpck 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 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.
Step 7 − Cpck on Multiples.
Step 8 − Cpck on the DESIGN tab on the ribbon.
Step 9 − Cpck on Other Chart in the Switch Visuapzation group.
Step 10 − Cpck on Line. You have created Horizontal Multiples of the Line charts.
Step 11 − Drag the Field in HORIZONTAL MULTIPLES to VERTICAL MULTIPLES. You have created VERTICAL MULTIPLES of Line Charts.
Visuapzation – 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 cpck 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 − Cpck the Tiles to move between the data for different Tiles. The data changes in the Stacked Bar Chart Visuapzation according to the selected Tile. All the content in the container is filtered by the selected Tile value.
The Tile container has two navigation strip types: tile flow and tab strip.
What you have created above is the tab strip. Tab strip displays the navigation strip across the top of the visuapzation.
Step 3 − Cpck on a Tile.
Step 4 − Cpck on the DESIGN tab on the ribbon.
Step 5 − Cpck on Tile Type in the Tiles group.
Step 6 − Cpck on Tile Flow.
The Tile flow displays the navigation strip across the bottom of the Visuapzation. The selected Tile is always centered.
You can cpck on the Tiles or you can Scroll through the Tiles by using the Scroll Bar. When you Scroll, the Tiles go on being selected.
Step 7 − Cpck on Map in the Switch Visuapzation group.
Step 8 − Drag Medal to Color.
Step 9 − De-select the Field Gender
You got Map Visuapzation with Tile Flow. Likewise, you can have any data visuapzation with Tiles.
Advertisements