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.
How many ears grow on a corn plant? Different corn plants have different numbers of ears, but much of the field corn grown in Iowa is bred to develop just one large ear rather than several incomplete ears. This approach usually yields better total production. How many kernels are there on an ear of corn? The number of kernels per ear can vary from 500 to about 1,200. A typical ear has about 800 kernels, according to corn experts. Imagine how many kernels are found in an acre of corn! How tall is a typical corn plant? A typical corn plant can be anywhere from five feet to 12 feet tall.