Handling Integers in Advanced Excel

A table can be converted into a chart with the help of a power view where one column of data has to be aggregated. Power View can aggregate both integer and decimal numbers. We can also aggregate the data models by other default behavior. Power View provides Power View Fields where the sigma symbol is present which helps to aggregate the data model by doing summation or average.

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.