It provides much of the same basic functionality as Excel, and creating the perfect graph for your data is also just as easy. Highlight the range of data you wish to represent in the graph.

Excel stops copying the formula when it reaches the last cell with adjacent data. Enter "=Average (C:C)-2.66*Average (A:A)" in cell D2 and copy the formula down the column to create the lower limit.

Excel offers a wide variety of charts and graphs, each designed to help you uniquely visualize data. But choosing the right chart isnt always straightforward.

Apr 22, 2013, 8:03 AM PT Bill Gates using an early version of Microsoft Excel Flickr / Microsoft Sweden Microsoft Excel is a crucial tool for anyone operating in modern business. But there are risks.

Use Excel's Charts button to select a type of graph, such as pie, and complete any step-though process to generate the graph. Then follow the rest of the instructions here.

Indeed, it's hard to take a chart seriously when its malformed legend is juxtaposed on top of a battleship grey background. You can fix your charts by buying Excel 2010.