Chart & Visualization Issues

Fix Excel Combination Chart Missing Series Chart Type Options

Maira Mehtab Sep 22, 2026 869 views

Question details

The user cannot change the chart type for specific series in an Excel combination chart because the series are missing from the Change Series Chart Type dialog, even though they appear in the Select Data menu.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a combination chart with a large dataset and formula-based series (such as Flow, Peak, Shaded, Max, and Min) to visualize complex data metrics.
Observed behavior: Certain series fail to appear in the Change Series Chart Type dialog, preventing the user from customizing the chart types for those specific data sets.

Before you start

Verify that you are using the latest version of Microsoft Excel, as rendering bugs related to complex charts and large datasets are frequently addressed in software updates.

Solution 1Recommended

Rebuild the Chart Step-by-Step on a Test Worksheet

Isolating the data and rebuilding the chart incrementally helps identify which specific formula or series is breaking the chart type dialog.

When dealing with large datasets and formula-based series (like calculating AM/PM shaded areas), Excel's charting engine can sometimes fail to render the settings dialog correctly. Rebuilding the chart on a clean sheet helps bypass internal workbook corruption.

Copy Data to a New Sheet

Copy your raw data and formula-based series, then paste them into a completely new, blank worksheet.

Simplify Complex Formulas

Temporarily replace highly complex formulas with static values to see if calculation limits are causing the issue.

Insert Base Chart

Select your core data range, go to the 'Insert' tab, and create a standard Combination Chart.

Add Series Incrementally

Add your additional series (Flow, Peak, Shaded, Max, and Min) one at a time via the 'Select Data' menu.

Test Chart Type Dialog

After adding each series, right-click the chart and open the 'Change Series Chart Type' dialog to identify exactly which series causes the options to disappear.

Data Complexity Limits: Large datasets combined with array formulas or dynamic ranges can overwhelm Excel's UI, causing certain chart customization windows to glitch.

Solution 2

Delete and Recreate the Chart

Sometimes the internal XML structure of a specific chart becomes corrupted, and creating a fresh chart can restore the missing series options.

Build Combo Charts Easily

Create Complex Combination Charts in WPS Spreadsheet

Avoid chart rendering errors by using WPS Office. WPS Spreadsheet smoothly handles large datasets and provides an intuitive, stable interface for building and customizing combination charts with multiple series.

1. Open Your Data: Launch WPS Spreadsheet and open your existing data file.
2. Select the Data Range: Highlight the cells containing the data and series you want to visualize.
3. Insert a Combo Chart: Go to the 'Insert' tab on the top ribbon and click on 'Chart'.
4. Customize Chart Types: Select 'Combo' from the chart type list. You will easily see all your series listed, allowing you to change the chart type and assign secondary axes for each one.
5. Generate the Chart: Click 'OK' to instantly generate your error-free combination chart.

Handles large datasets and complex formulas efficiently without UI glitchesFully compatible with Microsoft Excel (.xlsx) files and chartsIntuitive 'Change Chart Type' dialog for seamless series customizationFree and lightweight alternative to Microsoft Office

microsoft office alternative - wps office

Frequently Asked Questions

Why do some series show in 'Select Data' but not in 'Change Series Chart Type'?

This typically occurs when the dataset is excessively large, contains highly complex formula-based series, or when the chart's internal structure has become corrupted. Excel's UI may fail to render the customization options for complex data arrays.

Can I change a shaded area series type in an Excel combination chart?

Yes, but if the shaded area relies on complex conditional formulas (such as indicating AM/PM regions), the chart settings dialog may break. Try simplifying the series into static values or rebuilding the chart to restore the option.

Is there a limit to how many series I can have in an Excel combination chart?

Excel supports up to 255 series in a single chart. However, having multiple complex, formula-driven series (like Flow, Peak, Max, and Min) can cause performance issues and missing menu options long before you reach the maximum limit.

Excel & Data Problems