Open In App

Handling Integers in Advanced Excel

Last Updated : 12 Mar, 2023
Improve
Improve
Like Article
Like
Save
Share
Report

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.

Create a dataset

 

Step 2: Now just select the cell from A1 to B5.

Select the dataset

 

Step 3: Select the Insert tab on the top of the ribbon and then in the view group select the Power View option.

 Select the Insert tab

 

Step 4: Select the Design tab on the top of the ribbon and then choose Stacked Bar from Bar Chart.

Select the Design tab

 

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.

Stacked Bar chart will appear

 

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.

bar chart can be changed by its aggregate for Sigma values has to be changed.

 

Step 7: Select Count(Distinct) in Sigma Values so that Power View will count the field of Values.

Count(Distinct) in Sigma Values

 


Like Article
Suggest improvement
Previous
Next
Share your thoughts in the comments

Similar Reads