How to Create Comparison Bar Chart in Excel 2010?

Asked By sean.cole97 10 points N/A Posted on - 10/25/2012

Hi, I want to make a comparison chart in Excel 2010. (Comparison of Admin & Development Expenses with Revenue). The admin expenses have their own dates, development expenses have their own dates & revenue have their own dates.

I want to make a bar chart for it, where 1 bar will represent Expenses (Both Admin & Development) and the Other Bar will represent Revenue.

Please tell me, How can I make a comparison chart for it?

• Status: Open
• Question Views: 3063
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Riley weaver

Go To Solution

Answered By Sierra Adams 10 points N/A #117702

How to Create Comparison Bar Chart in Excel 2010?

Hi,

 

It’s very easy. Follow the following steps to make the comparison graph:

 

1. Create the new excel sheet.

2. Add columns.

3. Add data.

4. Click the chart wizard for new chart creation.

5. Select stacked columns for the chart.

6. Complete the wizard.

7. Right click on any column and select Format Data Series.

8. Select Options tab and add 0 for Gap Width.

9. Click on OK button.

 

I hope this information will helps you.

 

About Sierra Adams

Questions
1

Answers
101

Best Answers
39

• Vote Up 0 Vote Down

• Posted on - 10/25/2012
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Riley weaver 10 points N/A #117703

How to Create Comparison Bar Chart in Excel 2010?

Hi there,

This work is really an easy one. But for that you must have to know the tabs and few silly works. Now please follow the instructions below.

1.   Open a new workbook.

2.   Copy the data from every column and paste them into the new workbook.

3.   Select insert tab, in the middle of the submenu you will find chart.

4.   Now select the columns from the new workbook.

5.   Click on the chart icon and you will get the chart you are looking for.

You can easily show the comparison in the bar charts. I hope this will help you in your work.

Best regards,

Riley Weaver.

About Riley weaver

Questions
2

Answers
228

Best Answers
103

• Vote Up 0 Vote Down

• Posted on - 01/26/2013
• Question Category: MS Excel