Javatpoint Logo
Javatpoint Logo


A histogram chart is a chart that displays the shape of the distribution.

A histogram looks like a bar chart but group values for a continuous measure into range. In the histogram, each bar represents the height of the number of values present in that range.

To create a histogram, we need only one measure. It creates the additional bin field for the measure.

For example, consider the data source such as Sample-Superstore, and if you to find the Quantities of sales for different Segment. For this, follow the below procedure step by step, such as:

Step 1: Go to the worksheet.

Step 2: Drag the measure Quantity into the columns shelf.


Step 3: Click on the "show me" toolbar and select the histogram chart icon, shown in the below screenshot.


NOTE: The histogram chart is available in "show me" when the view contains only one measure and no dimensions.

Step 4: After selecting the histogram chart as the chart type. Then,

  • The view changes and shows vertical bars, with a continuous X-axis and Y-axis.
  • The measure Quantity with SUM aggregate in columns shelf is replaced by continuous Quantity(bin) dimension.
  • The Quantity field moves to the rows shelf and aggregation changes from SUM to CNT or (Count).

Step 5: Drag the dimension Segment and drop into the Color shelf under the Marks pane.


After adding the Segment field to Color shelf, you can see a relationship between the Segment field and the Quantity of item as per order is shown in the below screenshot.


Step 6: Hold the Ctrl key in the keyboard and drag CNT(Quantity) field from the rows shelf Label shelf under the Marks pane.


Step 7: Right-click on the CNT(Quantity) field in Marks pane. And

  • Click on the Quick Table Calculation option from the list.
  • Select the Percent of Total option.

Now each colored section of each bar shows its percentage of total quantity shown in the following screenshot.


Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA