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

  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.
iOS Create a Line Chart 1.png

  1. Go to the main menu by tapping on the icon with the three circles.
  2. If needed, view other menus by tapping "Home."
  3. Tap "Insert" to open that menu.
  4. On the Insert menu, tap "Charts."
iOS Create a Line Chart 2.png

  1. Tap "Line."
  2. Select the first chart. This is a simple line chart.
  3. The line chart will appear on the spreadsheet.
iOS Create a Line Chart 3.png

  1. If needed, tap on the chart to activate it.
  2. Tap on the chart elements icon at the bottom of the screen.
  3. Tap "Axis Titles."
  4. Tap "Primary Horizontal" and "Primary Vertical" in turn to add them to the chart.
  5. You can zoom in on the chart to edit the text boxes that appear.
iOS Create a Line Chart 3.1.PNG
iOS Create a Line Chart 3.2.png

  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.
iOS Create a Line Chart 4.png
iOS Create a Line Chart 5.png