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

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

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,144,210
Messages
5,723,050
Members
422,476
Latest member
beck85

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