Open Excel, select the data set, and select the line chart in the Insert menu bar to get the trend chart of the data set. From the chart, you can find that the data has a seasonal trend.
Set the series value name, select the data set column header, here select "Sales Revenue", and get the series name.
Edit the horizontal category axis label, select the "Year" and "Month" columns, and click OK.
In this way, you can see the two horizontal axis labels of month and year in the figure. The figure can not only show the overall growth trend of the curve, but also reflect the changes in different years. In addition, you can also find Seasonal changes in different months of the year.
In order to make the chart more beautiful, you can select "Chart Layout" in the "Design" menu and choose a reasonable layout method, so that the data change trend will be displayed more clearly.
6
If you find that the month is not fully displayed, enlarge the image in the lower right corner to fully display it. Finish.