Select the Format Data Series menu item.Right click on one of the data bars in the chart.
A histogram and a data table will be displayed. Ensure the Chart Output checkbox is ticked. For instance how many times did clients buy quantities of 10, 20, 30 etc. Bin numbers are the numbers that represent the intervals that you want the histogram tool to use. Place the cursor in the Bin Range text box. Input data is the data that you want to analyse by using the histogram tool.į.
A dialogue box like the below will appear.ĭ. Place the cursor in the Input Range text box. Tick the check box next to Analysis ToolPak and select OK.Į. The Analysis ToolPak is now available under the Data Tab in the Analysis group.Ĭ. Select Add– ins and next to Manage select Excel add-ins.ĭ. Note: Download the workbook to practice this exerciseī. This week, we’ll show you how to create a real histogram by installing the Analysis ToolPak which provides you with a host of data analysis tools. In our previous tip we showed you how to present data with PivotTable groupings and then add a column chart and convert that into a histogram.
