How to Create a Population Graph

You can create many styles of charts and graphs using Microsoft Excel.
••• business graphs image by Chad McDermott from <a href=''></a>

Population graphs are a way to easily see how a population is increasing or decreasing over time. Population graphs are usually displayed as line graphs: graphs with an x-axis and a y-axis that have one continuous line running from left to right. It's possible to draw a graph by hand, but if you make a mistake it can take a lot of time to erase and fix. Using a dynamic graphing software like Excel is not only easy and fast, but it allows you to correct mistakes in seconds.

    Enter your x-values into the "A" column of the Excel worksheet. Population graphs always have time (for example, days, months or years) on the x-axis. To plot a graph of the U.S. population over the last 30 years, put "1990" in cell A2, "2000" in cell A3 and "2008" in cell A4.

    Enter your y-values into the "B" column of the Excel worksheet. The U.S. population was 248,709,873 in 1990, 281,421,906 in 2000 and 304,059,724 in 2008, so enter those values into cells B2, B3 and B4, respectively.

    Enter your x-axis and y-axis labels into the worksheet. Put "Date" into cell A1 and "Population" into cell B1.

    Highlight the entire range of cells. Left click on cell A1, and drag the cursor to cell B4.

    Click on the "Insert" tab on the ribbon (the toolbar). Click on the down arrow beneath "Charts" and the down arrow beneath "Line." Choose "Line With Markers." This creates your population line graph.

    Click on the blue "date" line and hit the delete key to tidy up your graph.


    • You can change many aspects of your graph, including how the x-axis and y-axis are displayed. To change those settings, visit the "Axes" tab locate at "Chart Tools" then "Layout." To change inputs if you have made an error, change the information in the cell (not on the graph). Excel will update the graph with the new information.

Related Articles

How to Calculate the Time for Cell Doubling
How to Make a Monthly Budget Circle Graph
How to Use a TI-84 Plus
How to Do Algebra in Excel
How to Set Up a Pareto Chart in Minitab
How to Find the Slope of a Plotted Line With the TI-84...
How do I Calculate Cumulative Percentages?
How to Calculate a Demographic Percentage
How to Create a Normal Distribution Graph in Excel
How to Calculate NAIRU
How to Graph a Security Market Line
How to Figure Survey Percentages
How to Calculate Exponential Growth
How to Make Excel Calculate the Graph's Slope
How to Calculate Slope Using the TI-83 Plus
How to Graph a Distribution for a T-Test
How to Find Standard Deviation on a TI 84 Plus
How to Test Linearity in SPSS
How to Make a Semi-Log Graph on Excel?
How to Create a Population Density Map