Wednesday, February 15, 2012

How to Create a Curved Line Graph in Excel or Word

Microsoft Excel
1. Open Microsoft Excel. Highlight the data you want to insert in a graph.
2. Click the 'Insert' tab from the menu at the top of the page. You can insert pictures, clips and graphs here.
3. Look to the 'Charts' section on the drop-down menu. Select 'Line' and then choose either a 2-D or a 3-D line chart depending on your preferences. Your data will appear in a line graph.
4. Right-click on the line in the graph and select 'Format Data Series.' This is where you will choose options to make the line in the graph curved.
5. Select 'Marker Line Style' from the options at the right of the box that opens. Check the box that says 'Smoothed line' and click 'Close.' You will now have a curved line graph on your spreadsheet.
Microsoft Word
6. Open Microsoft Word. Click 'Insert' from the toolbar at the top.
7. Select 'Chart' and when the charts options box opens, choose 'Line' and click 'OK.'
8. Enter the data for the chart in the spreadsheet that appears. After you enter the data, close out the spreadsheet. The data will be applied to the graph on your document.
9. Right-click on a line in your graph and select 'Format Data Series.' Select 'Marker Line Style' and check the box that says 'Smoothed line.'
10. Click 'Close.' You will now have a curved line graph on your Word document.

Blogger news