How to Insert a Graph into your Excel Spreadsheet

Report information using a graph.

When reporting data or to get a better idea of what direction you company is heading, a graph is the easiest way to get a quick understanding of the data in front of you. Create a graph onto your Excel spreadsheet using three data sources, the date, total amount due, and total amount due greater than 60 days.

Difficulty:

Moderately Easy

Instructions

1. Click "Insert" and the click "Chart." The Chart wizard will appear on your computer.

2. Create a Line Graph by clicking line graph under the standard types.

3. Click on the small data range button; the Chard Wizard is now asking for you chart source data. This will bring up a small source data -- data range field. Go to your Excel spreadsheet and hold "Ctrl" and drag down the "lasso" to get all the information for the date.

4. Hold down the "Ctrl" button, drag and lasso the other two data sources. The date data, total amount due, and the total amount due greater than 60 days should all be "lassoed." Press "Enter"; this will bring you back to your chard wizard.

5. Click "Next." Now you can name your Chart Title, Category (X) axis, and Value (Y) axis.

6. Click "Finish" once named; this is going to post your graph to your spreadsheet as an object. If you don't like where the graph is posted, move the graph with your mouse.