Answer: Select the cells that you wish to draw the border around. Could someone tell me where to find instructions to make a histogram? Want to generate a line chart in Excel 2011? 2. Anyone viewing your spreadsheet will then be able to click that link to open a Web page. In one column you will place the data you want to present via histogram. Histogram Chart in excel is a data analysis tool that is used for showing the periodic rise and drop in the data with the help of vertical columns. This articles assists all levels of Excel users on how to load the Data Analysis Toolpak in Excel Mac. We’ll stick with the centuries-old tradition and gather some information about cities, starting with a table of income information about cities in the United States from the year 2009.
Enter your bin values, which display as the horizontal axis values on your histogram, in a single row or column, one per cell.