Microsoft Excel - Custom Combination Bar Chart: Data Table

[Manny74]

Hello, as I create a custom combination bar chart, I want the bars to only display the compliance rate for each department.
And when I add a data table to my chart, I only want to show the # Hand Hygiene and Compliance Rate.
When I right click on the bars, click on select data, I deselect # Hand Hygiene and # Observations, but then it also removes these items from the data table.
Is there a way where I can see the bars as Compliance Rate while the data tables shows # Hand Hygiene and # Observations?

	A	B	C	D
1	UNIT	# HAND HYGIENE	# OBSERVATIONS	COMPLIANCE RATE
2	ICU	120	200	60%
3	2ND FLOOR	155	200	78%
4	4RD FLOOR	175	200	88%
5	7TH FLOOR	195	200	98%
6	TOTAL	645	800	81%

 

[awoohaw]

This is nice!! But how again did you remove COMPIANCE RATE from the Data Table? I am trying to follow your instructions, but I am missing something.....Thank you for your patience....

there is no data table. ... the chart is between rows 5 and 23.

mr excel questions 32.xlsm
	A	B	C	D	E	F	G	H
1	UNIT	ICU	2ND FLOOR	4RD FLOOR	7TH FLOOR	TOTAL
2	# HAND HYGIENE	120	155	175	195	645
3	# OBSERVATIONS	200	200	200	200	800
4	COMPLIANCE RATE	60%	78%	88%	98%	0.81
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24		# HAND HYGIENE	120	155	175	195
25		# OBSERVATIONS	200	200	200	200
Manny74

Cell Formulas
Range	Formula
B24:F25	B24	=A2

 

[Manny74]

there is no data table. ... the chart is between rows 5 and 23.

mr excel questions 32.xlsm
	A	B	C	D	E	F	G	H
1	UNIT	ICU	2ND FLOOR	4RD FLOOR	7TH FLOOR	TOTAL
2	# HAND HYGIENE	120	155	175	195	645
3	# OBSERVATIONS	200	200	200	200	800
4	COMPLIANCE RATE	60%	78%	88%	98%	0.81
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24		# HAND HYGIENE	120	155	175	195
25		# OBSERVATIONS	200	200	200	200
Manny74

Cell Formulas
Range	Formula
B24:F25	B24	=A2

I think I see what you did, thanks!

 

[awoohaw]

I think I see what you did, thanks!

But it is really only effective if you are using the chart in a power point or other linked visualization where folks won't move columns/chart objects around.
If something that has been posted here provides you with a solution, please mark it as the answer.

Best wishes.