Chart & Visualization Issues

Select Nonadjacent Data Series for an Excel Chart on Android

Huda QurayshiHuda Qurayshi Nov 18, 2026 870 views

Question details

The user needs to create an Excel chart on an Android phone using data series in nonadjacent columns.

Select Nonadjacent Data Series for an Excel Chart on Android
Product
Microsoft Excel for Android
Device & OS
Android phone
Scenario
The required chart series are separated by columns that should not appear in the chart.
Observed behavior
Selecting one continuous range includes unwanted columns as chart data.
Before you start

Identify the category or X-axis column and the series columns you want to chart, including their headers. Check that the rows correspond across those columns.

Solution 1Recommended

Create a helper table with only the required columns

Use a contiguous helper table when selecting nonadjacent chart data is difficult on Android.

1
Choose an empty area

Open the workbook in Excel and find an empty area of the sheet or add a new sheet for the helper table.

2
Copy the chart columns

Select and copy the category or X-axis column, including its header, and paste it into the helper area. Copy each required series column beside it, keeping the rows aligned.

3
Select the helper table

Select the complete helper table, including the headers and all rows you want in the chart.

4
Insert the chart

Open Insert, choose Chart, and select a chart type. Check that the chart shows only the intended series.

Create a helper table with only the required columns
Updating the chart: Copied values do not automatically update when the original cells change. Update the helper table when needed, or use cell references in it if you want it to reflect changes to the source data.
Chart nonadjacent data on Android

Create a chart from selected columns in WPS Spreadsheet

In WPS Office on Android, place the columns you need in a contiguous helper table, then select that table to create your chart.

  1. 1. Open the workbook: Open WPS Office on your Android phone and select the spreadsheet containing your chart data.
  2. 2. Build a helper table: Copy the category column and each required series column into adjacent columns in an empty area or a new sheet. Include headers and keep the rows aligned.
  3. 3. Select the data: Select the helper table, including its headers and the rows you want to plot.
  4. 4. Insert a chart: Open Insert, tap Chart, and choose a chart type. Verify that the chart contains the intended series.
Chart only the required series by using a helper table.Open and edit Microsoft Excel XLSX and XLS spreadsheets.Work with spreadsheet data and charts on an Android phone.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel chart include extra series?

If you select a continuous range that includes unwanted columns, Excel may plot those columns as series. Create a helper table containing only the category column and the series you need, then chart that table.

Can I remove a series from a chart in Excel for Android?

Tap the chart and look for a Chart Data or Edit Data option in the chart controls. Individual series editing may not be available in every Android version; if you cannot remove a series, use a helper table to create a new chart.

Will a copied helper table update when the original data changes?

Pasted values will not update automatically. Update the copied cells yourself, or use cell references in the helper table so it reflects changes to the source cells.

Which columns should I include in the helper table?

Include the category or X-axis column and each series you want to plot. Copy their headers and make sure corresponding data stays on the same rows.