Changing source of the Bar in a bar of pie chart

[Learner007]

Bar of Pie chart.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
2
3
4
5
6
7		Sources	Food	120
8			Utilities	200
9
10			Electricity	50
11
12
13
14
15
16
17
18
19
20
Sheet1

I want to change this bar of pie chart to show the food and utilities split in the pie chart, with electricity being £50 of the £200 from utilities in the bar chart. I know that the electricity isn't showing at the moment because my data range is only food and utilities however if I change the range to include electricity, then the electricity is automatically shown in the pie chart. Is this possible? Thank you

 

[Learner007]

 

[Learner007]

Guessing this isn't possible so have found a way to force a similar effect.