Sunday, September 18, 2011

How to Create a Column Chart to Show Graphic Representation of Expenses on MS Excel


1. Type your data into a worksheet. Click on a cell, then type your data into the cells. In order for the column chart to work properly, you should enter your data in columns. For example, if you are comparing heights in inches of three people you might put 'John' into cell A1, 'Jane' into cell A2,'Bob' into cell A3 '72' in cell 'B1,' '69' in cell 'B2' and '75' in cell 'B3.'
2. Highlight the cells with your data by left clicking on the top left of the cells then dragging the cursor to the bottom right of the cells.
3. Click on the 'Insert' tab.
4. Click on the column' tab, then click on the column sub-type you want. For example, click on a '2-D Column' icon. Excel will insert a chart into your worksheet.

Blogger news