Monday, June 27, 2011

How to Make Line Graphs in Excel


1. Enter the values you wish to graph in a single column with no spaces.
2. If you wish to attach a descriptor to each value, enter the descriptor to the left of each number in the column. For example, if you want to see how much weight you've lost over time, list the date on the left and the value on the right for each time you've stepped on a scale.
3. Click and drag to highlight all the information you've just entered, including your descriptors. That should cause a blinking box to surround the data you wish to graph.
4. From the top menu, select 'Insert' and then 'Chart.' Choose 'Line graph' from the list of chart types, then select your preferred style from the thumbnails.
5. Follow the prompts to enter a title for your graph and label the X (horizontal) and Y (vertical) axes. Your descriptors should already appear along the X axis. You will then be allowed to choose whether to create your graph within your spreadsheet or on a new sheet.

Blogger news