Columnar Chart with 3 parts

[Hammer]

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.

 

[Mark W.]

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]

Yes, I tried to use the Chart Wizard with no luck. You're right, I want a columnar chart.

 

[Mark W.]

Perhaps your data isn't optimally arranged. Before choose the Chart Wizard select data arranged like this...

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	A	B	Total
2	2	8	10
3	1	7	8
4	2	4	6
5	3	5	8
6	5	7	12
7	1	6	7
8
Sheet4

 

[Hammer]

Thank you Mark - that did the trick.