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.