If you used column labels on the worksheet, you can include them in the cell references. Under Input, do the following: Click inside the Input Range box, and then select the cells in the first column of data.
Here's an example of two columns you could use for a histogram: On the Data tab, click Data Analysis. Here's how: On a worksheet, type the input data in one column, adding a label in the first cell if you want. Related articles:Ĭreate a histogram in Excel for Mac A histogram or Pareto sorted histogram is a column chart that shows frequency data. Tuesday, August 22, Create a histogram in Excel for Mac. Pareto sorted histogram This shows the data in descending order of frequency. How to create a histogram in Excel using Analysis ToolPak.Click in the sheet where you want your histogram to be placed.
