Columnar Chart with 3 parts

Hammer

New Member
Joined
Jun 2, 2002
Messages
9
Hi everyone,

I want to insert a bar chart that has each bar represent 3 parts. Specifically A inventory, B inventory and the total. I'd like each bar to show these parts in different colors.

Thanks in advance for any help.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Given your subject I assume that you want a Column Chart -- not a Bar Chart. Have you tried using the Chart Wizard? You can choose the desired chart type at step 1 of 4.
 

Hammer

New Member
Joined
Jun 2, 2002
Messages
9
Yes, I tried to use the Chart Wizard with no luck. You're right, I want a columnar chart.
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Perhaps your data isn't optimally arranged. Before choose the Chart Wizard select data arranged like this...
Book1
ABCDEFGHIJKL
1ABTotal
22810
3178
4246
5358
65712
7167
8
Sheet4
 

Forum statistics

Threads
1,181,448
Messages
5,929,968
Members
436,710
Latest member
CrazyCoop323

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top