How to create a line graph in microsoft excel 2007

The range of cells that make up a chart. The chart is updated automatically whenever the information in these cells changes. The vertical and horizontal parts of a chart. The vertical axis is often referred to as the Y axis, and the horizontal axis is referred to as the X axis.

Please re-enable javascript in your browser settings. Excel VBA Environ. A line chart is a graph that shows a series of data points connected by straight lines. It is a graphical object used to represent the data in your Excel spreadsheet. You can use a line chart when: You want to show a trend over time such as days, months or years.

In this case, the time values would be your categories. The order of your categories ie: time values is important. For more information about how to create these types of charts, see Available chart types in Office and Create a chart from start to finish. Note: If you select a picture marker, you must also complete step 6 to select the picture that you want to use. Note: This option is not available for picture markers. Make sure that the picture you want use is sized appropriately for your chart.

To change the look of the markers, click Marker Fill , and then select the options that you want. Tip: To fill a data marker with a picture, click Picture or texture fill , and then under Insert from , click File , Clipboard if you copied a picture there , or Clip Art to select the picture that you want to use.

Note: You cannot change the default settings for marker options. However, you can save your chart as a template that you can apply when you create another chart. Now when you view the chart, you should see that Series 2 has changed to a line graph.

However, we still need to set up a secondary Y-axis as Series 2 is currently using the primary Y-axis to display its data. To do this, right-click on one of the data points for Series 2 and select "Format Data Series" from the popup menu. Click on the Close button. Now, if you want to add axis titles, select the chart and a Layout tab should appear in the toolbar at the top of the screen.