Chart & Visualization Issues

How to Create Two Stacked Excel Graphs with Separate X and Y Axes

Huma Ashraf ChHuma Ashraf Ch Nov 2, 2026 871 views

Question details

The user wants to display two separate graphs positioned vertically (stacked one below the other), with each chart having its own independent X and Y axes.

How to Create Two Stacked Excel Graphs with Separate X- and Y-Axes
Product
Excel
Device & OS
not provided
Scenario
Creating advanced data visualizations where two distinct datasets need to be compared vertically without sharing the same axis scales.
Observed behavior
Needs to set up a dashboard-like view or combination panel chart to present two stacked charts with completely separate horizontal and vertical axes.
Before you start

Ensure your datasets are clearly organized into separate columns or tables before creating the charts, as this will make assigning independent axes and selecting data ranges much easier.

Solution 1Recommended

Create and Align Two Separate Charts Vertically

The simplest and most flexible way to have completely separate X and Y axes is to create two distinct chart objects and precisely align them one above the other.

By utilizing two separate chart objects, you retain complete control over both the primary horizontal and vertical axes for each dataset without dealing with complex secondary axis mathematical scaling.

1
Insert the first chart

Highlight the data for your first graph. Go to the 'Insert' tab on the ribbon, select your desired chart type (e.g., Line or Column chart), and place it on the worksheet.

2
Insert the second chart

Highlight the data for your second graph. Repeat the process to insert another chart into the same worksheet.

3
Standardize chart dimensions

Click on the first chart, go to the 'Format' tab, and note the exact Height and Width measurements. Apply these exact dimensions to the second chart so they match perfectly.

4
Align and stack the charts

Hold the 'Ctrl' key and click both charts to select them. Go to 'Shape Format' (or 'Format'), click 'Align', and choose 'Align Left' or 'Align Center'. Drag the second chart directly below the first one.

5
Group the charts together

With both charts still selected, right-click the border of one chart, select 'Group', and click 'Group'. This locks them together as a single stacked visual.

Create and Align Two Separate Charts Vertically
Pro Tip for Seamless Appearance: To make the two charts look like a single cohesive dashboard element, remove the bottom border of the top chart and the top border of the bottom chart in the Format Chart Area pane.
Easily Create Advanced Charts

Create Stacked Graphs Effortlessly with WPS Spreadsheet

WPS Spreadsheet provides intuitive charting tools, smart alignment guides, and advanced formatting options, allowing you to easily stack multiple graphs, assign secondary axes, and perfectly align your visualizations.

  1. 1. Open your data file: Launch WPS Spreadsheet and open the workbook containing your datasets.
  2. 2. Insert your charts: Select your separate datasets and use the 'Insert' tab to generate your desired charts independently.
  3. 3. Align using smart guides: Drag one chart below the other. WPS Spreadsheet's smart alignment lines will appear automatically, helping you snap the edges together flawlessly.
  4. 4. Customize axis elements: Double-click any axis to open the right-hand properties panel, where you can quickly hide overlapping labels or standardize dimensions.
Smart alignment guides to snap and perfectly stack multiple chart objects.Fully compatible with Microsoft Excel (.xlsx) chart formats.Create complex combination charts with a few simple clicks.Free, lightweight, and user-friendly spreadsheet solution.
microsoft office alternative - wps office

Frequently Asked Questions

Can I link the X-axes of two separate stacked charts so they update together?

Spreadsheet software does not natively link axes between two separate chart objects dynamically. However, you can manually set identical minimum and maximum bounds for the horizontal axes in the Format Axis pane to ensure they scale and align perfectly side-by-side.

How do I hide the X-axis on the top chart to make it look like one cohesive panel chart?

Select the horizontal axis on the top chart, right-click, and choose 'Format Axis'. Under the 'Labels' section, change the Label Position to 'None'. You can also remove the axis line in the 'Line' settings to create a seamless stacked appearance without duplicate labels.

Why are my secondary axes overlapping in a single combination chart?

In a single combination chart, data series on the primary and secondary axes will overlap by default. To visually separate them into a top and bottom section within one chart, you need to manually adjust the maximum and minimum bounds of both Y-axes to force the data plots into distinct halves of the chart area.