Unable to create a simple chart the selected data stays red see example below.

[loosetwig]

Unable to create a simple chart the selected data stays red see example below.

 

[awoohaw]

Hi, welcome to the forum.
Is this a chart to count the number of ocurrances of each statement? Can you describe the data range for the chart? And what kind of chart you want to have?

 

[awoohaw]

If you want a frequency chart then try this:

Source Data:

Mr excel questions 67.xlsm
	A	B	C	D	E
1
2	User Behavior Issue			User Behavior Issue	Count
3	User Access			Email Issue	8
4	User Access			User Access	7
5	User Access			Outbound Call Issue	5
6	Outbound Call Issue			Permissions	4
7	Outbound Call Issue			Login Issue	3
8	Outbound Call Issue			Inbound Call Issue	3
9	Outbound Call Issue			Contact List	2
10	Outbound Call Issue			Customer Care AR Update	2
11	User Access			Reporting	2
12	User Access			Genesys App Issue	2
13	Login Issue			WhatsApp Issue	1
14	Contact List			Network Related Issue	1
15	Contact List			API Related Issue	1
16	WhatsApp Issue			Audio Issue	1
17	Email Issue			Auto Answer	1
18	Network Related Issue			Queue	1
19	User Access			Call Alerting	1
20	Customer Care AR Update			Call Transfer	1
21	Customer Care AR Update
22	API Related Issue
23	User Access
24	Reporting
25	Reporting
26	Audio Issue
27	Email Issue
28	Auto Answer
29	Queue
30	Email Issue
31	Email Issue
32	Email Issue
33	Email Issue
34	Email Issue
35	Email Issue
36	Login Issue
37	Login Issue
38	Genesys App Issue
39	Call Alerting
40	Call Transfer
41	Inbound Call Issue
42	Inbound Call Issue
43	Permissions
44	Permissions
45	Permissions
46	Permissions
47	Genesys App Issue
48	Inbound Call Issue
49
loosetwig

Cell Formulas
Range	Formula
D3:E20	D3	=LET(Issue, UNIQUE(A3:A48),counts, COUNTIF(A3:A48,Issue), marray, HSTACK(Issue,counts), SORT(marray,2,-1))
A4:A5,A44:A46,A42,A37,A31:A35,A25,A21,A15,A12,A7:A10	A4	=A3
Dynamic array formulas.