Excel2013 Tutorial easy to produce a performance trend chart

Operation Steps:

1, first, the establishment of a simple tabular data, including names and sales of each month, select the table area, click the menu bar-insert-line chart, select the first two-dimensional line chart can be.

2, after the line chart generation, the right mouse click Blue Polyline, from the pop-up right-click menu to choose Set data series format.

3, pop-up Settings data series Format pane, Drop-down scroll bar, in the series options to check the "smooth line."

4, the same, but also click to select the Yellow polyline, right-click, set the data series format.

5, the Shanping slip line, the purpose is to make the line formed by the line into a curved, similar to the sine cosine.

6, click a vertex on the curve, that is, the top of the graph, which represents the maximum, in the Set Data Point format pane, check the built-in, type dot or other, size of 6.

7, repeat step 6, the blue and yellow curves on the operation, as shown in the following figure.

8, then right click on the horizontal axis, right-click menu, select Add Minor gridlines.

9, the position of the axis on tick-mark line, close the pane.

10, cancel some unnecessary things, the legend set under the chart, the final effect, you can view the following figure.

Note : More wonderful tutorials Please pay attention to the triple Office software tutorial section, triple Computer office group: 189034526 welcome you to join