Colored Pie Chart for Column

[jarett]

Trying to display the values in column "I" as a pie chart to show which reason is getting the larger amount of instances "in the pie". When I try to insert a chart I am getting a lot of numeric values, and I am trying to do this by highlighting just this column. I assume I am going about this all wrong. Could the colors in the pie chart resemble the columns format or will I have to format the pie chart as well?

Inv_Quality_Control_Log.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		QUALITY CONTROL LOG TEMPLATE
2		COMPANY	ACTION SPECIALTIES
3		DEPARTMENT	INVENTORY
4		PROJECT NAME	INVENTORY DISCREPENCY REASONS
5		PROJECT MANAGER	JARETT LANDRY
6
7		SALES ORDER NO	STATUS	PRIORITY	ITEMCODE	RAISED BY	DATE DISCOVERED	DATE OF ERROR	REASONS		PRIORITY		STATUS		REASONS
8		19810	Complete	Medium	112PFP-EDBN-A/TAKEN	RECEIVING	03/20/24	08/23/23	Multiple Issues		Low		Not Started		Miscount
9		8440607	Complete	Low	202-BLACK-L	RECEIVING	03/20/24	03/31/23	Production Damaged		Medium		In Progress		Production Damaged
10		8416909	Complete	Medium	10FR31MWZ-3632	SHIPPING	03/21/24	06/20/23	Duplicate Entry		High		Complete		Company Store
11		20509	Complete	Medium	LK810-WHEAT-M	PICKING	03/21/24	11/01/23	Order Deleted				Needs Review		Duplicate Entry
12		8448017	Complete	High	GB00264-100W	PICKING	03/22/24	03/06/24	Company Store				On Hold		Timing
13		18382	Complete	High	112-BW-A/ WAREHOUSE, TIMING, COUNT	PICKING	03/22/24	02/28/24	Multiple Issues						Multiple Issues
14		19210	Complete	High	411064-BLACK/SILVER-OSFA	CRM	03/22/24	08/22/23	Company Store						Order Deleted
15		20502	Complete	Medium	64000-CAROLINABL-L/ SCHOOLS, PRODUC.	PICKING	03/22/24	05/15/23	Multiple Issues
16		8446064	Complete	Medium	8000-KELLY GREEN-XL/ COUNT, USED	PICKING	03/22/24	06/30/23	Multiple Issues
17		8445815	Complete	Low	PC20CH-38-32/SO RETURN	PICKING	03/25/24	09/23/23	Multiple Issues
18		8447789	Complete	Medium	CT89520701-BLACK-OSFA/ SO <> PO	PICKING	03/25/24	02/22/24	Order Deleted
19		8447413	Complete	Medium	FRT-USHLSP6GY 4XL RE/ RETURN PROCESS	PICKING	03/26/24	11/03/23	Duplicate Entry
20		20774	Complete	Medium	L572-BLACK-S/ OG	PICKING	03/26/24	08/31/23	Order Deleted
Quality Control Log Template

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O8:O14,I8:I115	Cell Value	contains "Order Deleted"	text	NO
O8:O13,I8:I115	Cell Value	contains "Issues"	text	NO
O8:O13,I8:I115	Cell Value	contains "Timing"	text	NO
O8:O13,I8:I115	Cell Value	contains "Duplicate Entry"	text	NO
O8:O13,I8:I115	Cell Value	contains "Company Store"	text	NO
O8:O13,I8:I115	Cell Value	contains "Production Damaged"	text	NO
O8:O13,I8:I115	Cell Value	contains "Miscount"	text	NO
K8:K10,D8:D115	Cell Value	contains "Low"	text	NO
K8:K10,D8:D115	Cell Value	contains "Medium"	text	NO
K8:K10,D8:D115	Cell Value	contains "High"	text	NO
M8:M12,C8:C115	Cell Value	contains "Needs Review"	text	NO
M8:M12,C8:C115	Cell Value	contains "Not Started"	text	NO
M8:M12,C8:C115	Cell Value	contains "On Hold"	text	NO
M8:M12,C8:C115	Cell Value	contains "Complete"	text	NO
M8:M12,C8:C115	Cell Value	contains "In Progress"	text	NO

Cells with Data Validation
Cell	Allow	Criteria
C8:C115	List	=$M$8:$M$12
D8:D115	List	=$K$8:$K$12
I1:I20	List	=$O$8:$O$15

 

[sxhall]

Hi Jarett,

If you add a COUNTIF to the right of the 'reasons' in column O and then select range O8:P14, insert pie chart, you get the below. I formatted each legend entry to match the colour of the reason as well, you'll only need to do this once for the graph.

=COUNTIF($I$8:$I$21,O8)