Create Pivot Chart

[GMC The Macro Man]

Hi there
I am being extremely stupid here, but I cannot get a simple Pivot Table to create a Pivot Chart. In the sheet attached, I have 2 columns, "Tracking Grade" and "Working Grade". The number range will be from 1-9
I just want a bar graph that will count the number of 1 - 9's in Tracking and the number of 1-9' s in Working. (It will be a pivot chart as the numbers will change periodically)

In this sheet I only have 2 numbers, 6 and 7 to make it easy . In tracking, there are 32 number 6 and 4 number 7, and in Working there are 22 number 6 and14 number 7, however when I create my Pivot Table It does not calculate correctly (See image)
Can anyone help before I have no more hair left
TIA

Book1
	C	D	E	F	G
2	Tracking Grade	Working Grade		Tracking	Working
3	6	6		6 = 32	6 = 22
4	6	6		7 = 4	7 = 14
5	6	6
6	6	6
7	6	7
8	6	6
9	7	7
10	6	7
11	6	7
12	6	6
13	7	7
14	6	6
15	6	6
16	7	7
17	6	6
18	6	7
19	6	7
20	6	6
21	6	7
22	6	6
23	6	7
24	7	7
25	6	6
26	6	6
27	6	6
28	6	7
29	6	7
30	6	6
31	6	6
32	6	6
33	6	6
34	6	6
35	6	6
36	6	6
37	6	6
38	6	7
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3:D38	Cell Value	between 7 and 9	text	NO
C3:D38	Cell Value	between 5 and 6	text	NO
C3:D38	Cell Value	between 3 and 4	text	NO
C3:D38	Cell Value	between 1 and 2	text	NO

 

[DanteAmor]

You must identify each number with its respective "Grade", for example:

Dante Amor
	C	D
1	GRADE	NUMBER
2	Tracking Grade	6
3	Tracking Grade	6
4	Tracking Grade	6
5	Tracking Grade	6
6	Tracking Grade	6
7	Tracking Grade	6
8	Tracking Grade	7
9	Tracking Grade	6
10	Tracking Grade	6
11	Tracking Grade	6
12	Tracking Grade	7
13	Tracking Grade	6
14	Tracking Grade	6
15	Tracking Grade	7
16	Tracking Grade	6
17	Tracking Grade	6
18	Tracking Grade	6
19	Tracking Grade	6
20	Tracking Grade	6
21	Tracking Grade	6
22	Tracking Grade	6
23	Tracking Grade	7
24	Tracking Grade	6
25	Tracking Grade	6
26	Tracking Grade	6
27	Tracking Grade	6
28	Tracking Grade	6
29	Tracking Grade	6
30	Tracking Grade	6
31	Tracking Grade	6
32	Tracking Grade	6
33	Tracking Grade	6
34	Tracking Grade	6
35	Tracking Grade	6
36	Tracking Grade	6
37	Tracking Grade	6
38	Working Grade	6
39	Working Grade	6
40	Working Grade	6
41	Working Grade	6
42	Working Grade	7
43	Working Grade	6
44	Working Grade	7
45	Working Grade	7
46	Working Grade	7
47	Working Grade	6
48	Working Grade	7
49	Working Grade	6
50	Working Grade	6
51	Working Grade	7
52	Working Grade	6
53	Working Grade	7
54	Working Grade	7
55	Working Grade	6
56	Working Grade	7
57	Working Grade	6
58	Working Grade	7
59	Working Grade	7
60	Working Grade	6
61	Working Grade	6
62	Working Grade	6
63	Working Grade	7
64	Working Grade	7
65	Working Grade	6
66	Working Grade	6
67	Working Grade	6
68	Working Grade	6
69	Working Grade	6
70	Working Grade	6
71	Working Grade	6
72	Working Grade	6
73	Working Grade	7
Hoja3

That way you can create the pivot table and put a row for each number:

I hope that helps you.

 

[GMC The Macro Man]

Hi Danteamor

Thank you for taking the time to review my issue.
Unfortunately the columns in my report are side-by-side so your suggestion would not work but you did make me understand where I was going wrong so I created a little Helper page to copy the data and do the pivot table / Chart and this works perfectly

Thank you again
GMC