Browse » Home
Tuesday, May 17, 2011
How to Create a Histogram in Excel
1. Type or import data into an Excel spreadsheet. Organize data into columns representing the 'Input Range,' representing data range on the y-axis, and the 'Bin Range,' representing frequency values on the x-axis.
2. Verify the 'Analysis ToolPak' option under Tools/Add-Ins has been checked or activated. If 'Data Analysis' option isn't available, please see the 'Tips' section for activating the Analysis ToolPak under the 'Add-Ins' menu.
3. Click on the 'Data Analysis' option under the 'Tools' menu.
4. Open the 'Histogram' option window.
5. Select 'Input Range' by dragging your mouse over the data you want to include in the analysis.
6. Choose 'Chart Output.'. Your chart will appear within the same Excel worksheet as your data.
7. Use 'Chart Options' and 'Format Data Series' menu to adjust the final appearance of the chart. You can use these options to adjust, size, position and labeling.