Line Chart in Excel
A line chart distributes category data evenly along a horizontal (category) axis , and distributes all numerical value data along a vertical (value) axis.
Line charts can display continuous data over time, set against a common scale, and are therefore ideal for showing trends in data at equal intervals or over time. In a line chart, category data is distributed evenly along the horizontal axis, and all value data is distributed evenly along the vertical axis. As a general rule, use a line chart if your data has non-numeric x values — for numeric x values, it is usually better to use a scatter chart.
Create a line chart
So, how did we create this line chart? The following procedure will help you create a line chart with similar results. For this chart, we used the example worksheet data. You can copy this data to your worksheet, or you can use your own data.
- Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot into a line chart.How to copy the example worksheet data
- Create a blank workbook or worksheet.
- Select the example in the Help topic.
NOTE: Do not select the row or column headers.
Selecting an example from Help - Press CTRL+C.
- In the worksheet, select cell A1, and press CTRL+V.
|
|
- Select the data that you want to plot in the line chart.
- On the Insert tab, in the Charts group, click Line.
- Click Line with Markers.
- Click the chart area of the chart.This displays the Chart Tools, adding the Design, Layout, and Format tabs.
- On the Design tab, in the Chart Styles group, click the chart style that you want to use.
For our line chart, we used Style 2.
- On the Layout tab, in the Labels group, click Chart Title, and then click Above Chart.
- Click the chart title, and then type the text that you want.For our line chart, we typed Particulate Levels in Rainfall.
- To reduce the size of the chart title, right-click the title, and then enter the size that you want in the Size box on the shortcut menu.For our line chart, we used 14.
- On the chart, click the legend, or select it from a list of chart elements (Layout tab, Current Selection group, Chart Elements box).
- On the Layout tab, in the Labels group, click Legend, and then click the position that you want.For our line chart, we used Show Legend at Top.
- To plot one of the data series along a secondary vertical axis, click the data series for Rainfall, or select it from a list of chart elements (Layout tab, Current Selection group, Chart Elements box).
- On the Layout tab, in the Current Selection group, click Format Selection.
- Under Series Options, select Secondary Axis, and then click Close.
- On the Layout tab, in the Labels group, click Axis Titles, and then do the following:
- To add a primary vertical axis title, click Primary Vertical Axis Title, and then click the type of vertical axis title that you want.For our line chart, we used Rotated Title.
- To add a secondary vertical axis title, click Secondary Vertical Axis Title, and then click the type of vertical axis title that you want.For our line chart, we used Rotated Title.
- Click each title, type the text that you want, and then press ENTER.For our line chart, we typed Particulate level in the primary vertical axis title, and Daily Rainfall in the secondary vertical axis title.
- Click the plot area of the chart, or select it from a list of chart elements (Layout tab, Current Selection group, Chart Elements box).
- On the Format tab, in the Shape Styles group, click the More button
, and then click the effect that you want to use.For our line chart, we used the Subtle Effect – Dark 1.
- Click the chart area of the chart.
- On the Format tab, in the Shape Styles group, click the More button
, and then click the effect that you want to use.For our line chart, we used the Subtle Effect – Accent 3.
- If you want to use theme colors different from the default theme that is applied to your workbook, do the following:
- On the Page Layout tab, in the Themes group, click Themes.
- Under Built-in, click the theme that you want to use.
- On the Page Layout tab, in the Themes group, click Themes.
Line charts can use the following chart subtypes.
- Line and line with markers Displayed with markers to indicate individual data values, or without, line charts are useful to show trends over time or ordered categories, especially when there are many data points and the order in which they are presented is important. If there are many categories or the values are approximate, use a line chart without markers.
- Stacked line and stacked line with markers Displayed with markers to indicate individual data values, or without, stacked line charts can be used to show the trend of the contribution of each value over time or ordered categories, but because it is not easy to see that the lines are stacked, consider using a different line chart type or a stacked area chart instead.
- 100% stacked line and 100% stacked line with markers Displayed with markers to indicate individual data values, or without, 100% stacked line charts are useful to show the trend of the percentage each value contributes over time or ordered categories. If there are many categories or the values are approximate, use a 100% stacked line chart without markers.
TIP: For a better presentation of this type of data, consider using a 100% stacked area chart instead.
- 3-D line 3-D line charts show each row or column of data as a 3-D ribbon. A 3-D line chart has horizontal, vertical, and depth axes that you can modify.
This information is as per a Microsoft” Excel Support Post