Re: How do I change the y-axis on an Excel chart from numbers towords. This will plot everything as zero values, since they are all text. You can fake it using one of these approaches: http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html. http://peltiertech.com/Excel/Charts/DotPlot.html. - Jon.
First you must keep in mind that all ears of corn have an even number of rows, never an odd number. All average ears have between 12 and 20 rows. Still, it's difficult to tell at a glance whether an ear has 14, 16, 18, or 20 rows.
Ear Size Determination. Row number and kernel number per row are two of several yield components in corn. Typically, from 750 to 1000 ovules (potential kernels) develop on each ear shoot. The number of kernel rows multiplied by the number of kernels per row determines total kernel number per ear. Actual (harvestable) kernel number per ear averages between 400 and 600. For a 16-row ear, one kernel per row is equal to about five bushels per acre (for average populations). Like so many other processes in the corn plant, kernel row number determination on an ear proceeds in an acropetal fashion (from base to tip).