More than one category in x-axis [message #674596] |
Fri, 27 May 2011 13:48 |
Satyaki Messages: 1 Registered: May 2011 |
Junior Member |
|
|
hello,
i have a requirement to generate a chart (bar) with the below dataset.
Birth Wt and In/Out Born should appear in the x-axis.
Count of Boy / Girl should appear in the y-axis.
For every Birth Wt category, there are 2 sub categories, In / Out Born.
I am just not able to figure out how do i represent 2 categories in the x-axis.
Birth Wt In/Out Born Boy Girl
<1000 Inborn 8 5
Outborn 7 3
1000-1499 Inborn 14 0
Outborn 9 4
1500-2499 Inborn 22 6
Outborn 13 8
>=2500 Inborn 27 9
Outborn 25 11
I am attaching an xls sheet with the data table and a chart which would help you understand the requirement much better. I wonder how easy it is to do such things in xls.
Any help would be much appreciated and i am eagerly looking forward to it.
Best regards,
Satyaki.
|
|
|
Powered by
FUDForum. Page generated in 0.02930 seconds