provides examples of Formulas, Functions and Visual Basic proceduresįor illustration only, without warranty either expressed or implied, includingīut not limited to the implied warranties of merchantability and/or fitness forĪ particular purpose. The tip in this show is from Excel for Scientists and Engineers E-Book. You can easily compare male vs female results for each age bin. On the Patterns tab, find the checkbox to have the labels appear as 'Low'. If you would like the category bins to appear on the left axis, right click the >70 label and choose Format Axis. This will prevent the left side of the chart from appearing with negative values. In the Format Axis dialog, apply a custom number format of 0% 0% 0%. Right-click the percentages along the bottom of the graph. In the Paste Special dialog, choose Values and Multiply. Then, select the values for the Male series. Select this cell and type Ctrl+C to copy the cell to the clipboard. Enter the value of -1 in an out of the way cell. To make a dual-sided histogram, you need to show one of the series as negative. Right-click any bar and choose Format Data Series. This doesn't get you much closer to a histogram. You get a typical accounting chart as shown here.įrom the menu, select Chart - Chart Type.

Highlight the range shown above and type the F11 key. Your goal is to create a two-sided histogram to show results of this data. Excel can make graphs useful for scientists, but they often have to wade through charts for accountants first. Today's tip is taked from Gerry Verschuuren's book. I recently published a new book that takes a look at Excel for Scientists and Engineers. However, Excel is also a favorite tool for scientists. Many of the tips at are accounting-oriented.

How to do a histogram in excel