having problems with pivot charts

[alirezamohammadi]

Hello to eveyone
I want to get a pivot chart from a table that the horizontal axis has subcategory and I really dont have an idea how can I make that how ever I can not specify categories to special axis

Book1
	A	B	C	D
1	basement poylgons	target ratio	displacement(cm)	Initial displacement(cm)
2	triangle	0.3		4.89222
3		0.4	1.433475
4		0.6	2.633913
5		0.8	4.565209
6	squere	0.3	1.5786	4.012732
7		0.4	1.520199
8		0.6	1.590207
9		0.8	1.542845
10	pentagone	0.3	3.525635	2.989105
11		0.4	1.746645
12		0.6	8.762971
13		0.8	4.628362
14	hexagone	0.3	9.644201	2.53341
15		0.4	1.387029
16		0.6	2.397022
17		0.8	4.201455
18	octagone	0.3	1.698331	4.466333
19		0.4	2.349611
20		0.6	3.454928
21		0.8	3.466977
22	circle	0.3		4.398317
23		0.4	13.071494
24		0.6	5.23081
25		0.8	2.415884
Sheet1

 

[mart37]

When you have a pivot chart you see on the right side the task pane with pivotfields. Put the categories in the box: Axis