How to Create Comparison Bar Chart in Excel 2010?

Asked By 10 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by Riley weaver
Answered By 10 points N/A #117702

How to Create Comparison Bar Chart in Excel 2010?

qa-featured
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.
 
Best Answer
Best Answer
Answered By 10 points N/A #117703

How to Create Comparison Bar Chart in Excel 2010?

qa-featured

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.

Related Questions