How to Make a Graph in the Google Sheets Mobile App

To make a graph in the Google Sheets mobile app, select the cells you want to show, tap the plus (+) button, choose Chart, and adjust the chart settings if needed. Before you start, arrange your information in a clear table with headings so Sheets can identify the labels and values correctly.

A graph in Sheets is called a chart in the app. You can create one on an Android phone, iPhone, or tablet, then change its type and appearance on your device. The exact layout of the controls can vary slightly by operating system, screen size, and app version, but the basic process is the same.

What You’ll Need

The Google Sheets app installed on your Android device, iPhone, or tablet, and access to the Google account or spreadsheet you want to use.
A spreadsheet containing the data for your graph. Put related information in a simple table, with a heading for each column and one row per item or time period.
A working internet connection if the file is stored online and not available for offline use. The app may let you work offline with an available file, but changes will sync when you reconnect.

Step-by-Step

Open the spreadsheet. Launch the Google Sheets app and open the file containing your data. If you are starting from scratch, tap the create button to make a blank spreadsheet, then enter your table. For example, you could put months in column A, website visits in column B, and sign-ups in column C. Keep each type of information in its own column.
Check the table before selecting it. Add a descriptive heading at the top of each column, such as Month, Visits, and Sign-ups. Keep the headings in one row, and avoid blank rows or columns inside the data. Make sure the values you want to plot are numbers or dates, not numbers stored as text. A chart can still be made without headings, but its labels may be less useful.
Select the cells for the graph. Tap the first cell in the table and use the selection handles to extend the highlighted range over the headings and every row or column you want to include. For the example above, select the heading row and all three columns of data. If you select only the values, the chart may show generic labels instead of month names or series names.
Insert the chart. With the range highlighted, tap the plus (+) icon, usually found near the top of the screen. In the menu that opens, tap Chart. Sheets will create a chart using the selected cells and place it in the spreadsheet. On some screen sizes, you may need to scroll through the Insert menu to find the chart option.
Choose a chart type. If the chart editor opens, tap the chart type control and select the style that suits the information. A line chart is usually a good starting point for values changing over time. A column or bar chart can compare categories, while a pie chart is best reserved for a small set of parts that make up one whole. If the first choice is not helpful, you can change it later.
Review the chart’s data setup. Check that the labels and series are in the right places. For a time-based table, months or dates should normally appear as the horizontal labels, with each numeric column represented as a series. If the chart seems to treat rows as series when you expected columns, look in the chart editor for the option to switch rows and columns. The wording or availability of setup controls can differ between app versions.
Add a clear title and labels if the editor offers them. Tap the chart to open its available editing controls, then choose Edit chart if that option appears. Look for chart or axis title settings and enter a short title that says what the data measures. For example, “Monthly Website Visits” tells a reader more than “Results.” If title controls are not available in your app version, leave the chart as is and finish those details later in Sheets on a computer.
Confirm your changes. Use the check mark, back arrow, or on-screen confirmation shown by your device to apply the edits. The chart should appear on the sheet. Tap outside it to return to the spreadsheet, then scroll if necessary to see the whole chart. If the chart editor remains open, use the device’s back control or the editor’s close control to leave it.
Resize or move the chart. Tap the chart to select it. If handles appear around its border, drag a corner handle to make it larger or smaller; drag the chart itself to reposition it, where the app allows. Avoid covering the source table if you still need to read or edit it. On a phone, turning the device sideways can make a wide chart easier to inspect.
Check the finished graph against the table. Compare a few plotted values with their original cells and make sure the categories are in the expected order. Confirm that the chart includes all intended rows and that the title, if present, describes the data accurately. Changes to the source cells generally update the chart automatically, so you can correct the table rather than recreate the graph if a value is wrong.

Common Mistakes

Selecting an incomplete range: Leaving out the heading row or the last few entries can produce generic labels or a chart that appears to omit data. Before inserting the graph, look at the highlighted range and check its first and last rows.
Including unrelated cells: A note, total, or extra column inside the selection may be treated as chart data. Select only the table you intend to visualize. If a total should not be plotted alongside the individual values, leave it outside the selected range.
Choosing an unsuitable chart: Pie charts are hard to read with many categories, and line charts can imply a continuous sequence when the categories are unrelated. Match the chart to the question: compare categories with bars or columns, show a trend with a line, and use a pie only for a few meaningful shares of one total.
Mixing labels and numbers in one column: Text mixed into a numeric series can result in missing points or confusing chart behavior. Keep category names in one column and numeric measurements in another. Check that dates are recognized as dates if you want them shown in time order.
Assuming the chart editor has every desktop control: The mobile app has a more compact set of editing options, and some controls may appear differently or not be available. If you cannot find a detailed formatting setting, use Sheets in a desktop browser rather than repeatedly tapping through unrelated menus.

Tips

Make the source table easy to interpret. Use one clear header row, consistent units, and a sensible order for categories. A chart is only as clear as the data behind it.
Start with the simplest useful chart. Try a column chart for a quick category comparison or a line chart for a sequence over time. Change the style only if it makes the pattern easier to understand.
Keep the number of series manageable. Adding many columns can make a phone-sized graph crowded. If several series overlap or the legend takes up most of the chart, consider charting fewer columns or splitting the information into separate graphs.
Use descriptive headings from the start. Column headings often become the chart’s legend labels. “Revenue” or “Temperature” is more useful than “Series 1,” and a heading with a unit, such as “Distance (km),” helps prevent ambiguity.
Zoom and rotate to inspect details. Pinch to zoom the sheet if you need to select cells precisely. A landscape view can make it easier to read a wide table or compare the chart with its data, though the controls may move as the screen rotates.
Remember that the chart stays with the spreadsheet. You do not need to export it just to keep it. The inserted chart is part of the sheet and can be revisited or edited when you reopen the file.

Troubleshooting

You cannot find Chart in the plus menu: First check that you have opened the file in the Google Sheets app rather than a preview or another spreadsheet app. Confirm that cells are selected, tap the plus icon, and scroll the Insert menu. If the app is out of date, update it through your device’s app store and try again.
The chart is blank or has no useful labels: Return to the sheet and check the selected cells. Include the label row and the numeric values, and remove blank rows or unrelated text from the middle of the range. If cells that look like numbers are being ignored, check whether they were entered or imported as text.
The wrong information appears on the horizontal axis: Tap the chart and open Edit chart if available. Review the setup and look for a control to switch rows and columns. If the mobile editor does not show that setting, rearrange the source table into a clear layout or make the change in Sheets on a computer.
The chart is too small or difficult to select: Tap near the chart edge, not on a label, and look for selection handles. Zoom in on the sheet or rotate the device to landscape. If mobile resizing is awkward, open the same spreadsheet on a computer to adjust the chart more precisely.
Your edits do not appear on another device: Check that the phone is online and that the app has finished syncing. Confirm that you are signed in to the same Google account and opened the same file. Wait briefly, then close and reopen the spreadsheet; avoid making competing edits in separate copies of the file.
You need a formatting option that is missing: Mobile controls can be limited. Open the spreadsheet in Google Sheets in a web browser on a computer and select the chart to use its fuller chart editor. The desktop interface differs from the mobile app, so its menus will not match the tap-by-tap steps above.

Frequently Asked Questions

Can I make a graph in the Google Sheets app on an iPhone?
Yes. Select the data, tap the plus (+) button, and choose Chart. The arrangement of editing controls may differ slightly from Android.

Can I make a graph on Android?
Yes. In the Sheets app, select the cells, tap the plus (+) button, and tap Chart. You can then adjust the chart using the editing options shown on your device.

What is the difference between a graph and a chart in Google Sheets?
People often use “graph” for any visual display of data. Google Sheets calls the inserted visual a chart; the steps are the same.

Can I change the chart type after creating it?
Usually, yes. Tap the chart and choose Edit chart, then select a different type if that control is available. If you cannot see the option in the app, edit the chart in Sheets on a computer.

Will the graph update when I change the data?
Generally, yes, as long as you edit cells included in the chart’s source range. New rows added outside that range may not appear automatically, so check the chart’s data range or extend the selection when needed.

Can I create a graph from non-adjacent cells on mobile?
It can be difficult to select separate ranges in the mobile app, and the available controls vary. For the most reliable result, arrange the information together in a small table first, or use the desktop chart editor to specify the data ranges.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.