How to Chart Data Series with Very Different Values in Excel
Question details
The user needs to visualize multiple time-based data series in a single chart where the numerical values differ drastically in scale.

- 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.
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.
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.
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.
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).
Right-click the selected line and choose 'Format Data Series' from the context menu.
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.

Apply a Logarithmic Scale
Use a logarithmic scale when multiple series cover exponential ranges, allowing the axis to display percentage changes uniformly.
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. Open your data file: Launch WPS Spreadsheet and open the document containing your time-based data.
- 2. Insert a Combo Chart: Highlight your data, navigate to the 'Insert' tab, click on 'Chart', and select the 'Combo' chart type.
- 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. 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.

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.




