Return to site

How to do a histogram in excel

broken image

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.

broken image

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.

broken image