Chart & Visualization Issues

How to Chart Data Series with Very Different Values in Excel

Camila MilosovichCamila Milosovich Nov 10, 2026 869 views

Question details

The user needs to visualize multiple time-based data series in a single chart where the numerical values differ drastically in scale.

How to Chart Data Series with Very Different Values in Excel
Product
Microsoft Excel / WPS Spreadsheet
Device & OS
not provided
Scenario
Creating a time-based chart to compare multiple variables that have vastly different numeric ranges, such as one series under 1 and another over 20,000.
Observed behavior
When plotted normally on a single primary axis, smaller values become invisible as a flat line at the bottom, while the larger values dominate the chart space.
Before you start

Ensure your data is organized cleanly with dates in a single column and the respective data series in adjacent columns. Identify which specific series contains the significantly larger or smaller values before creating your chart.

Solution 1Recommended

Use a Secondary Axis for Outlier Data

Plot the series with significantly different scales on a secondary Y-axis to make both data trends visible without distorting the chart.

Adding a secondary axis is the most common and effective way to handle two data series with entirely different magnitudes. It adds a second vertical scale on the right side of the chart.

1
Insert a basic chart

Select your entire data range, navigate to the 'Insert' tab on the ribbon, and click 'Insert Line or Area Chart' to create a standard 2D line chart.

2
Select the data series

Click directly on the line in the chart that represents the data series with the vastly different values (you may need to select it from the Chart Elements dropdown if it's too small to click).

3
Format Data Series

Right-click the selected line and choose 'Format Data Series' from the context menu.

4
Enable Secondary Axis

In the Format Data Series pane under 'Series Options', click the radio button for 'Secondary Axis'. A new vertical axis will appear on the right side of your chart.

Use a Secondary Axis for Outlier Data
Pro Tip: To make the chart easier to read, change the chart type of one series to a Column chart by right-clicking it and selecting 'Change Series Chart Type'. This creates a distinct Combo chart.

Create Complex Multi-Axis Charts Easily in WPS Spreadsheet

WPS Spreadsheet offers a robust charting engine that perfectly handles data with different scales. You can quickly add secondary axes, change chart types for specific series, and customize logarithmic scales with an intuitive, highly compatible interface.

  1. 1. Open your data file: Launch WPS Spreadsheet and open the document containing your time-based data.
  2. 2. Insert a Combo Chart: Highlight your data, navigate to the 'Insert' tab, click on 'Chart', and select the 'Combo' chart type.
  3. 3. Assign the Secondary Axis: In the chart creation dialog, simply check the 'Secondary Axis' box next to the data series that requires a different scale.
  4. 4. Customize and format: Use the quick chart tools on the right of the chart to adjust legends, axis titles, and colors to make your data pop.
Easily plot multiple data series on secondary axes with just a few clicks.Full compatibility with Microsoft Excel (.xlsx) chart formats and features.Rich gallery of customizable combo chart templates for advanced data visualization.Lightweight, fast, and free to use for your daily spreadsheet needs.
microsoft office alternative - wps office

Frequently Asked Questions

Does Excel have a built-in broken Y-axis chart feature?

No, Excel does not have a standard built-in feature for a broken Y-axis. The best alternatives are using a secondary axis, applying a logarithmic scale, or physically splitting the data into two separate charts stacked vertically with synchronized horizontal axes.

Why does my secondary axis chart look cluttered?

When multiple line charts overlap heavily, they can intersect in ways that make reading the trends difficult. Try changing the chart type of one data series to a column or bar chart (creating a Combo chart) to distinguish visually between the two different scales.

Can I add a third axis to my Excel chart?

Excel only supports a primary and a single secondary vertical axis (two vertical scales maximum). If you have three series with completely different scales, you should either normalize the data to percentages, use a logarithmic scale, or create entirely separate charts.