Chart & Visualization Issues

Fix Blank Chart Type Page When Creating a Combo Chart in Excel

Kushani Nimanthika Oct 16, 2026 869 views

Question details

The user is experiencing a blank chart-type page when attempting to select the Combo chart option to create a combination chart with lines and bars.

How to Fix a Blank Combo Chart Type Page in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a combination chart using the Change Chart Type dialog menu.
Observed behavior: Selecting the Combo option results in a completely blank setup page rather than showing the expected chart customization options for lines and bars.

Before you start

Ensure your selected data range contains at least two distinct columns or rows of numerical values, as combination charts require multiple data series to render properly.

Solution 1Recommended

Adjust Data Structure to Include Multiple Series

Ensure your dataset contains the necessary multiple data series required to generate a combination chart, which resolves the blank page error.

The Custom Combination option may fail to load and show a blank page if the selected data does not meet the minimum requirements. Specifically, Excel needs multiple numerical data series to plot different chart types (like lines and bars) simultaneously.

Verify your data structure

Check your worksheet to ensure you have at least two separate columns containing numerical values (for example, one column for Sales and another for Profit Margin).

Select the entire data range

Highlight the entire dataset you want to chart, making sure to include the header row so the chart labels are generated correctly.

Open the Chart dialog

Navigate to the Insert tab on the ribbon, click on Recommended Charts, and then switch to the All Charts tab.

Select the Combo option

Click on Combo at the bottom of the list. Because your data now has multiple valid series, the options will populate correctly instead of showing a blank page.

Adjust Data Structure to Include Multiple Series

Data Format Check: Make sure your numerical columns are actually formatted as numbers and not stored as text, as text values will prevent the chart from rendering.

Easily Create Combination Charts with WPS Spreadsheet

WPS Office offers an intuitive and seamless way to create professional combination charts without running into blank configuration pages. It flawlessly handles multiple data series to help you build visually appealing line and bar charts in seconds.

1. Select your data: Open your workbook in WPS Spreadsheet and highlight the data range containing your categories and multiple numerical series.
2. Insert a chart: Go to the Insert tab on the top menu and click on the Chart icon to open the chart creation dialog.
3. Choose the Combo type: In the Chart dialog box, select Combo from the left-hand pane.
4. Customize and apply: Choose which data series should be plotted as a Column and which should be a Line, check Secondary Axis if needed, and click OK.

Intuitive chart creation wizard with live previewsFully compatible with Microsoft Excel (.xlsx) file formatsFree and lightweight alternative for seamless data visualization

microsoft office alternative - wps office

Frequently Asked Questions

Why do I need two data columns for a combo chart?

A combo chart combines two different chart types, such as a column chart and a line chart. Without at least two numerical data series, the software cannot plot two distinct chart types simultaneously, resulting in missing options or a blank page.

Can I add a secondary axis to my combination chart?

Yes. Once your combo chart options load, you can check the 'Secondary Axis' box next to one of your data series. This allows you to plot values with drastically different scales on the same chart without flattening the smaller values.

What should I do if my chart is still blank after fixing the data?

Try clearing all formatting from your data cells, ensure there are no hidden rows or columns within your selection, and make sure none of the cells contain error values like #DIV/0! or #N/A before re-selecting the data range.

Excel & Data Problems