Monday, July 23, 2012

How to Make a Double Bar Graph on Microsoft Excel


1. Open a new Excel 2010 document.
2. Enter the names of the items you want on your double bar chart, starting in cell B1 and continuing to the right of that cell. These headers will become the labels printed at the base of each of the bar sets on the graph.
3. Type the names of the two categories that the double bar graph will track into cells A2 and A3. These labels will be located to the right of the bar graph. Each of these two categories will be assigned a color bar, which will appear next to each of the items on the graph.
4. Input your numerical data into the cells, starting with cell B2 and continuing down and to the right. When you're done entering information, select cell A1 and hold down the mouse button. Move the mouse to the bottom-right cell and release the button.
5. Select the 'Insert' tab at the top of the screen. Click the 'Bar' button located in the 'Charts' area of the ribbon. Choose any of the 'Clustered' bar chart options, as opposed to the 'Stacked' options. Your double bar chart will appear on the spreadsheet.

Blogger news