Handling integers in Advanced Excel involves working with whole numbers and performing calculations such as sum, average, count, minimum, and maximum. Tools like Power View make it easier to analyze integer data by automatically aggregating numeric fields and displaying them in visual formats such as charts.
Step-by-step Implementation
Follow the further steps to handle the integers using advanced excel.
Step 1: First we create sample data with fields sports and No. of Medals.
Step 2: Now just select the cell from A1 to B5.
Step 3: Select the Insert tab on the top of the ribbon and then in the view group select the Power View option.
Step 4: Select the Design tab on the top of the ribbon and then choose Stacked Bar from Bar Chart.
Step 5: Now Stacked Bar chart will appear where No. of Medals has been taken as aggregate by Power View because that is the numeric field.
Step 6: The bar chart can be changed by its aggregate for Sigma values has to be changed. So that bar chart can get changed by the average, minimum, maximum, count of no. of medals.
Step 7: Select Count(Distinct) in Sigma Values so that Power View will count the field of Values.
