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.
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.