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.

Line chart

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

Line chart showing phone, tablet, and laptop sales

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

Combo chart

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%