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.
The USDA uses a bushel as its official measuring unit for corn. A bushel of corn is 56 pounds. Using the standard dry-moisture rate of 15.5 percent, it takes roughly 70.7 ears of dry corn to produce one bushel. Therefore, the ideal weight of one ear of corn is 1.26 pounds. The USDA estimates that 158.8 bushels of corn is produced for every acre of crop planted. This equates to roughly 11,227 ears of corn (14,146.02 pounds) produced per acre.