Have to Graph some data that involves the population within an age group. The lowest number on the graph needs to be 3,700,000 and the highest 4,800,000. I plot the data BUT can not seem to figure out how to adjust the settings to get the lower number I need. Divisions should be "11" but
- Object; Graph; Type; Graph Options; Value Axis - but then I can not enter 3,700,000 as the minimum.
How do I get there folks??
Yes, that helped.
I changed the numbers moving the decimal point from 4,069,320 to 4,069.32. This allowed the points to plot correctly. Then changed my Low and High Value Axis numbers to 3,700 and 4,800 with 11 divisions. The numbers on the left have to many decimal points BUT I can easily edit those numbers as the plotted points are accurate.