If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating Histograms using Excel
I am having problems creating a historgram using Excel.
Specifically with regards to entering the data in the correct format so that a chart can be produced. I have already created my data array and will need to create two histograms; one with 5 classes and one with 15. Any help would be greatly appreciated. Thanks, Stacy |
#2
|
|||
|
|||
Hi Stacy -
If the Analysis Toolpak is installed, you can choose Data Analysis from the Tools menu, and scroll down to Histogram. It asks you to specify the data, and you can define your own bins or let Excel define them for you. Alternatively, you can define your own bins, and use the FREQUENCY worksheet function to total up the data, then make a column chart. Both of these approaches are described in more detail he http://peltiertech.com/Excel/Charts/Histograms.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Stacy wrote: I am having problems creating a historgram using Excel. Specifically with regards to entering the data in the correct format so that a chart can be produced. I have already created my data array and will need to create two histograms; one with 5 classes and one with 15. Any help would be greatly appreciated. Thanks, Stacy |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating spreadsheets in Excel | Anne | General Discussion | 1 | October 18th, 2004 03:09 PM |
importing tabs with leaders from Word into Excel, or creating variable length "dots" in Excel | Chica | Worksheet Functions | 3 | November 25th, 2003 08:06 PM |