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.
AGR-187 Estimating Corn Yields Chad Lee and Jim Herbek, Grain Crops Extension, Plant and Soil Science Example 1: You count 12 rows per ear and 50 kernels per row to equal 600 kernels per ear. 600 x 0.300 = 180 bushels/acre Example 2: You count 12 rows per ear and 50 kernels per row to equal 600 kernels per ear. If you assume 25,000 ears per acre, then: