Back
Create a Line Chart - Excel Android App

Line charts can illustrate what are called data series. A data series is a group of data with similar characteristics. They can be in rows or columns. Below, you can see two series of data in columns: (a) dates, (b): sales numbers. Both data series have a title (Date, Sales).

  1. Tap a cell at the top of one of the series. This will create a box around the cell with a circle at the bottom.
  2. Tap, hold, and drag the circle so the box surrounds both series. Be careful not to include data that is not in the series. In this case, we do not include cell D12 because it is not a sales number for a certain date.
Callout number one is pointing at the title, Date, under column C. Callout number two is pointing at the circle located at the bottom right of the selected cells under the columns for Date and Sales.


  1. If needed, go to the main menu by tapping on the icon with a small arrow in the bottom right corner.
  2. If needed, view other menus by tapping "Home."
  3. Tap "Insert" to open that menu.
  4. On the Insert menu, tap the arrow on the "Charts" menu item.
Callout number one is pointing at the arrow located at the bottom right corner of the screen to show the menu. Callout number two is pointing at the Home menu. Callout number three is pointing at the Insert menu. Callout number four is pointing at the arrow next to the Chart option.


  1. Tap the arrow in the "Line" menu item.
  2. Select the first chart. This is a simple line chart.
  3. The line chart will appear on the spreadsheet.
Callout number one is pointing at the arrow next to the Line option. Callout number two is pointing at a Line chart option. Callout number three is pointing at the chart that will pop up in the middle of the screen.


  1. If needed, tap on the chart to activate it.
  2. If needed, open the main menu and tap on "Chart."
  3. Tap on the arrow in the "Elements" menu item.
  4. Tap on the arrow in the "Axis Titles" menu item.
  5. Tap "Primary Horizontal" and "Primary Vertical" in turn to add them to the chart.
  6. You can zoom in on the chart to edit the text boxes that appear.
Callout number one is pointing at the Sales chart. Callout number two is pointing at the Chart menu and the drop down arrow located at the top right corner of the menu.

    Callout number three is pointing at the arrow next to the Elements option. Callout number four is pointing at the arrow next to the Axis Titles option. Callout number five is pointing at both Primary Horizontal and Primary Vertical options. Callout number six is pointing at the vertical axis title, Dollars.


    1. You can tap, hold, and drag the chart to position it on the spreadsheet.
    2. You can also resize the chart. Tap on it once to activate the circles on every corner. Tap, hold, and drag a corner to resize.
    Callout number one is pointing at the chart, and callout number two is pointing at the circle located at the bottom right corner of the chart.