Microsoft Excel is spreadsheet software that aids you in storing, manipulating and managing large amounts of data. Excel comes with various tools that help you to display data trends, including charts and graphs. Whether you need a bar graph to display sales data, or a histogram to show how your data falls into categories, Excel can help you create a professional and accurate graph in minutes. Depending on which type of chart you would like, your data should be ordered in two columns (for a bar chart) or one column (for a histogram).
1. Select your data with your mouse by left clicking on the top left cell and dragging the cursor to the bottom right cell.
2. Click on the “Insert” tab.
3. Choose the type of graph you would like. For a bar graph, click on “Bar” and then click on the type of bar chart you would like (for example, 2D or 3D).
4. Click “OK.”
5. Enter your bin widths next to your data. Bin widths are how wide you want your categories to be. For example, if you are looking at the price of new cars, you might want bins (or categories) of $0 to $5000, $5000 to $10,000, and $10,000 to $15,000. Enter 5000 in cell B2, 10,000 in cell B3, and 15000 in cell B4.
6. Click on “Data Analysis” from the “Data” tab.
7. Click on “Histogram” option. Press “OK.”
8. Enter the bin ranges in the “bin range” box. For example, if you your bins (from Step 1) are in cells B2 to B4, enter “B2:B4” in the box.
9. Press “OK” to create the histogram.