Line charts

Use a line chart when you want to find trends in data over time. For example, get trends in sales or profit margins each month, quarter, or year.

How to format your data

First column: Enter a label to describe the data. Labels from the first column show up on the horizontal axis.
First row (Optional): In the first row of each column, enter a category name. Entries in the first row show up as labels in the legend.
Other columns: For each column, enter numeric data. You can also add a category name (optional).
Other cells: Enter the data points you’d like to display.
Rows: Each row represents a different line in the chart.

Tip: If the chart doesn’t show the data on the axis you want, learn how to switch rows and columns.

Month Phones Tablets Laptops

Jan 76 10 30

Feb 69 18 25

March 45 35 35

April 74 60 50

May 65 55 40

June 80 67 42

Use a combo chart when you want to represent different data series using lines and bars.

Year	Revenue	Net Income	Profit margin
2014	43,000ドル	5,900ドル	14%
2015	56,400ドル	8,800ドル	16%
2016	67,988ドル	10,500ドル	15%
2017	78,333ドル	13,500ドル	17%
2018	94,500ドル	16,500ドル	17%