Dynamic Chart Help

[dext]

Hi,

I seem to be having issues trying to create a dynamic chart, i have the following information, I have a drop down menu in column h1 which has all my months listed from October 22 - September 24, i then try and insert a pie chart, but everything i try i cannot get this pie chart to change with the months, can anyone help and give me step by step instructions, I've been trying for two days and getting nowhere.

 

[awoohaw]

I don't see any of the rows adding to 100%, which is what pie charts usually do?
So, please tell us what row or section of column is supposed to be in your pie?

please describe what you wouild want in a static chart. and then we can try to figure out how to make it dynamic.

 

[dext]

this is the 4 tables i have created, i need a pie chart for each individual table, this is basically a utilisation chart, it will not add up to 100% i can create the drop down, i just cant link it together so the pie chart changes it just wont work whatever i do

 

[awoohaw]

please to help me understand. Just give me the values needed for 1 pie and 1 pie only? (what range(A:5:A10 or A5:E5))

 

[dext]

this is what i get when i create the pie chart

 

[awoohaw]

Ok and you want to make it dynamic as you add more rows?

 

[dext]

please to help me understand. Just give me the values needed for 1 pie and 1 pie only? (what range(A:5:A10 or A5:E5))

ok so october 22 will show the percentages for adult coaching, matches, social, member, junior coaching, in the pie chart, and then whenever i use the drop down menu for the different months it will change the pie chart

 

[dext]

Ok and you want to make it dynamic as you add more rows?

so when i enter the data for april and so on this will change the chart, i hope im making sense,

 

[awoohaw]

Make a dedicated area for the values to feed into the chart. Driven by a drop down. You can move the chart over the dedicated area so it is obscured, or put it in an area away from view.

But, pie charts have gone out of disfavor for visualizations. A bar or column chart that is sorted descending or ascending is more descriptive. Especially since you are not adding up to 100%.
drop down is in J2 (Yellow Highlight)

or you could use the MAX function to determine the last row:

Book1
	J	K	L	M	N	O
2	Sep-24
3	Adult Coaching	Matches	Social	Member	Junior Coaching
4	7.13%	3.85%	7.92%	6.51%	5.45%
Sheet1

Cell Formulas
Range	Formula
J2	J2	=MAX(A3:A500)
J4:N4	J4	=INDEX(B3:F26,MATCH(MAX(A3:A500),A3:A26,0),0)
Dynamic array formulas.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2		Adult Coaching	Matches	Social	Member	Junior Coaching			Select M/Y:	Dec-22
3	Oct-22	9.85%	5.45%	5.81%	4.02%	6.94%				Adult Coaching	Matches	Social	Member	Junior Coaching
4	Nov-22	6.89%	4.74%	1.74%	2.17%	6.05%				7.22%	9.30%	7.91%	7.30%	6.81%
5	Dec-22	7.22%	9.30%	7.91%	7.30%	6.81%
6	Jan-23	2.60%	9.37%	4.05%	7.27%	9.13%
7	Feb-23	8.80%	5.88%	7.34%	7.27%	7.01%
8	Mar-23	8.53%	4.67%	1.43%	8.07%	6.55%
9	Apr-23	9.79%	9.57%	3.02%	4.52%	3.97%
10	May-23	2.69%	4.78%	7.67%	3.37%	2.58%
11	Jun-23	9.12%	9.84%	4.27%	8.60%	5.32%
12	Jul-23	8.49%	8.77%	7.87%	5.16%	7.38%
13	Aug-23	7.80%	5.44%	8.31%	7.72%	3.20%
14	Sep-23	4.23%	8.41%	7.03%	5.58%	5.03%
15	Oct-23	1.85%	3.41%	2.82%	6.19%	3.62%
16	Nov-23	5.99%	7.53%	6.01%	3.14%	9.16%
17	Dec-23	8.35%	9.80%	7.17%	7.13%	7.73%
18	Jan-24	6.00%	2.69%	4.21%	2.84%	3.93%
19	Feb-24	4.61%	1.46%	7.40%	1.08%	8.58%
20	Mar-24	7.73%	9.22%	1.73%	5.97%	9.83%
21	Apr-24	9.25%	8.46%	8.03%	3.68%	4.58%
22	May-24	2.28%	7.35%	3.48%	4.33%	1.85%
23	Jun-24	2.79%	7.57%	9.64%	1.09%	4.95%
24	Jul-24	4.19%	9.35%	7.97%	8.53%	2.58%
25	Aug-24	4.45%	2.82%	4.95%	5.67%	3.19%
26	Sep-24	7.13%	3.85%	7.92%	6.51%	5.45%
Sheet1

Cell Formulas
Range	Formula
J4:N4	J4	=INDEX(B3:F26,MATCH(J2,A3:A26,0),0)
Dynamic array formulas.

Cells with Data Validation
Cell	Allow	Criteria
J2	List	=$A$3:$A$26