Histogram microsoft excel mac 2011

This add-in is not supported in Excel Online Office However, you can view a histogram created in a desktop version of Excel using Excel Online.

Create a histogram

To begin, enter the data you want to use in your histogram into a worksheet. For example, enter the names of the students in a class in one column and their test scores in another. Go to the Insert tab and select Recommended Charts in the Charts group. Right-click the vertical axis the numbers beneath the chart and select Format Axis to open the Format Axis pane and customize the histogram.

Create a Histogram Graph in Excel

Select Bin Width to customize the size of each bin. For instance, if the lowest grade in your dataset is 50 and you enter 10 in the Bin Width box, the bins will display as , , , and so on. Choose Overflow Bin or Underflow Bin to group above or below a specific number. Excel or earlier requires the Analysis ToolPak add-in to use the histogram tool.

Leave a Reply

Choose Excel Add-ins in the Manage drop-down, then select Go. Enter the data you want to use in your histogram into a worksheet. Enter the bin numbers you want to use into a third column. For instance, if you want to display test scores by letter grade, you might enter 40, 50, 60, 70, 80, 90, and into the cells of the third column.

Go to the Data tab. In the Analysis group, select Data Analysis. The Histogram dialog box will open.

Create a histogram - Office Support

Select the Input Range which would be the test scores in this example and the Bin Range which are the cells containing the bin numbers. Choose the Output Range if you want the histogram to appear on the same worksheet. Otherwise, choose New Worksheet or New Workbook. Select the Chart Output checkbox, then select OK. Excel will insert a static histogram on the sheet you selected. Exit Excel and restart the program.

The Data Analysis option will appear on the Data tab. For example: Click the Chart Output checkbox, then click OK. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Mike Middleton Replied on September 17, Thanks for marking this as the answer. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Article Author. As McGimpsey said, there are very simple ways to make a histogram, and more elaborate ways. You don't need anything other than Microsoft Excel to make a histogram.


  • aerofly 5 mac for sale.
  • How to Make a Histogram in Excel;
  • How do you create a histogram in excel for mac? - Microsoft Community.
  • How do you create a histogram in excel 2011 for mac?;
  • avery templates for mac address book!

If you want to make a very nicely formatted histogram without a lot of bother, follow the instructions I put on this web page: This site in other languages x.