Create a Line Chart - Excel iOS 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).

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.
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 for column C, Date. Callout two is pointing at the circle at the bottom-right corner that you can drag down to select a range of cells.

Go to the main menu by tapping on the icon with the three circles.
If needed, view other menus by tapping "Home."
Tap "Insert" to open that menu.
On the Insert menu, tap "Charts."

Callout number one is pointing at the three dots located at the bottom right of the screen that will bring out the menu once you tap it. Callout number two is pointing at the Home menu button. Callout number three is pointing at the Insert menu, and callout number four is pointing at the Charts option.

Tap "Line."
Select the first chart. This is a simple line chart.
The line chart will appear on the spreadsheet.

Callout number one is pointing at the Line option under Charts menu. Callout number two is pointing at a line chart option. Callout number three is pointing at the chart that will show up in the middle of the spreadsheet.

If needed, tap on the chart to activate it.
Tap on the chart elements icon at the bottom of the screen.
Tap "Axis Titles."
Tap "Primary Horizontal" and "Primary Vertical" in turn to add them to the chart.
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 elements icon at the bottom of the screen.

Callout number three is pointing at the Axis Titles option. Callout number four is pointing at the Primary Horizontal and Primary Vertical options under Axis Titles. Callout number five is pointing at the vertical axis title, Dollars.

You can tap, hold, and drag the chart to position it on the spreadsheet.
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.

A callout is pointing at the chart with an arrow that also points to it. This means that you can drag the chart any where in the spreadsheet.

Callout number two is pointing at the chart. This shows that when you tap at the chart, circles will appear in every corner that will let you resize the chart.