Chart showing function results

[Charlotte]

Hi,

I have the result of a small survey and I would like to have a clustered column chart showing the number of family that have two cars (13 family), the number of family that have 0 car (1 family), the number of family that have 4 cars (1 family) and so on ?

Thank you,
Charlotte

Mr Excel.xls
	A	B	C	D
1	Numberofcarsperfamily
2	0		Mode:	2
3	2
4	1
5	2
6	1
7	2
8	2
9	2
10	2
11	1
12	2
13	3
14	1
15	1
16	2
17	3
18	4
19	3
20	2
21	2
22	2
23	1
24	2
25	2
Mode

 

[PaddyD]

hi - have you tried a pivot chart?