This histogram macro is to be used in Microsoft Excel. It will create a histogram for every column of data that you've selected, and will place the histogram in a new worksheet. It will also create a worksheet called "My Histograms" that contains them all.
| 1. Set up Excel. Make sure you have installed Excel's Analysis Toolpak (go to Tools -> Add Ins... Excel may ask you for the installation discs) | |
| 2. Download and install macro Download the macro here | |
| 3. Format the data. Place all the data for a chip in a column, with the name of the chip (e.g. 'Patient 20') as the first cell in the column. Make sure nothing but the name and the data is in the column. | |
| 4. Run the Macro. Highlight the first cell of the column (the name), and go to Tools -> Macro ->Macros... One of the choices in the box that appears should be Histogram. Highlight that macro and click Run | |
| 5. Make multiple histograms. You can run the macro on multiple columns of data by Ctrl-clicking the first cell of each column, then running the macro. | |
| Results: The data will be plotted as a histogram with the bins you chose on the x-axis, and the log of the number of data in the bin on the y-axis. | |