How to Make a Double Bar Graph

1. Open an Excel spreadsheet.
2. Enter the data that needs to be charted, making sure to save frequently to insure no work is lost.
3. Click 'Insert' on the tool bar.
4. Go down to 'Chart' and right click the mouse. This opens the Excel Chart Wizard. This allows you to customize the type of chart you want to use to best show the data.
5. Choose 'Column' and select the double bar graph pictured among the choices.
6. Click 'Next' at the bottom of the list of options located at the bottom of the chart wizard.
7. Select the cells that hold the information you are charting. Place your mouse at the top of the first cell. Right click your mouse and do not let go. Drag to the bottom corner of the last cell of data and then let go of the mouse. This will create a box around the data you need to chart.
8. Keep the Excel Chart Wizard open and you will notice that the cell formula is auto entered for you.
9. Select 'Next' from the bottom of the Excel Chart Wizard for the next two options. This tells the chart wizard what to do with the specified data.
10. Choose 'Titles' from the top of the Excel Chart Wizard to enter a title for your graph, likewise choose 'Data Labels' and 'Data Table' to place text in the graph for easier understanding.
11. Select 'Next' to determine if you want the graph to show in the Excel Spreadsheet or if you want to show it as a separate page.
12. Click on 'Finish' to close the Excel Chart Wizard. Your graph will appear as you have selected.
13. Right click on 'Legend' on the graph itself to make changes. Choose 'Format Legend' from the choices and you are then able to change colors, add text, change fonts or add borders.