Saturday, December 24, 2011

How to Combine Bar Graphs in Excel


1. Open the document with the data that you would like to combine into one bar graph. If you have created any graphs or charts at this point, delete them by right-clicking and selecting 'Delete.'
2. Highlight only the data for the first graph. For example, if you wanted to combine the 'Expenses' and 'Profit' graphs together, only highlight one of those pieces of information.
3. Click 'Insert' and choose 'Bar' from the 'Charts' group. Choose the specific type of bar graph that you would like. It should appear to the right of the information you highlighted.
4. Highlight the second set of data, making sure to unhighlight the first set of data. Press 'Ctrl c' to copy the information. Click on the graph and press 'Ctrl v.' This should insert the second set of information into the graph. Repeat for any other pieces of information.

Blogger news