Select Nonadjacent Data Series for an Excel Chart on Android
Question details
The user needs to create an Excel chart on an Android phone using data series in nonadjacent columns.

- 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.
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.
Create a helper table with only the required columns
Use a contiguous helper table when selecting nonadjacent chart data is difficult on Android.
Open the workbook in Excel and find an empty area of the sheet or add a new sheet for the helper table.
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.
Select the complete helper table, including the headers and all rows you want in the chart.
Open Insert, choose Chart, and select a chart type. Check that the chart shows only the intended series.

Remove unwanted series from an existing Excel chart
Try this if your Android version of Excel provides controls for editing individual chart series.
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. Open the workbook: Open WPS Office on your Android phone and select the spreadsheet containing your chart data.
- 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. Select the data: Select the helper table, including its headers and the rows you want to plot.
- 4. Insert a chart: Open Insert, tap Chart, and choose a chart type. Verify that the chart contains the intended series.

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.




