Choosing fields for the pivot tableĪs we can see in Image 4, the pivot table is created, but we need to set the data appropriately, so we can create a histogram. We can drag and drop the “Sales” field into Rows and values: Now we need to choose fields in order to create the pivot table. We included the whole table including the header. In our case, the range is B2:D26 on Worksheet “Table”. In the popup screen, we need to select a table in “Table/Range” option. In the Insert tab, we choose button “PivotTable”. First, we will create a new Worksheet called “Pivot”. Now when we have data ready, we can create the pivot table. In the pivot table, we want to present the number of sales in each interval.
This table will be the data source for the pivot table. Let’s look at the data that we will use:Īs we can see in Image 1, our table in Worksheet “Table” consists of 3 columns: “Product” (column B), “Month” (column C) and “Sales” (column D). To be able to create a pivot table and chart, we need to set up the table with data first. We will present a number of sales within several equal sales intervals (210-309, 310-409, etc.).Ĭreating the Data Source for the Pivot Table In this article, we will explain a histogram usage on the example of multiple product sales. A histogram is often used to present the number of students with a number of points in a range (55-64, 65-74, 75-84, etc.) or a number of people in age groups (0-7, 8-15, 15-22, 23-30, etc.). In this step by step article, we will show you how to make a pivot chart histogram in Excel using pivot table as a data source. A histogram is a chart presentation of data grouped in equal intervals.
0 kommentar(er)
