Chart & Visualization Issues

How to Show Specific Y-Axis Values on Excel Scatter Charts

Tauseeq Magsi Oct 9, 2026 868 views

Question details

The user needs to display specific, non-linear values (0.1, 1, 10, 100, 1000) on the Y-axis of a scatter plot instead of the automatic linear intervals.

How to Display Specific Custom Y-Axis Values on an Excel Scatter Chart

Product: Microsoft Excel
Device & OS: Mac
Scenario: Customizing axis labels for a scatter plot containing data that spans several orders of magnitude.
Observed behavior: Excel automatically assigns evenly spaced linear Y-axis labels and does not natively support typing arbitrary, non-linear numeric labels directly into the standard axis properties.

Before you start

Ensure your scatter chart is already inserted with your dataset selected. Since your desired values are multiples of 10, using a logarithmic scale is the most accurate and efficient approach.

Solution 1Recommended

Apply a Logarithmic Scale to the Y-Axis

The best way to display base-10 values (like 0.1, 1, 10, 100) on a chart without distorting the data plot is to format the axis as a logarithmic scale.

A logarithmic scale changes the Y-axis increments to be powers of a base number (typically 10) rather than equal linear additions. This is ideal when comparing data over a huge range of values.

Open Axis Properties

Double-click the Y-axis numbers directly on your scatter chart to open the Format Axis pane on the right side of the screen.

Enable Logarithmic Scale

In the Format Axis pane, click the Axis Options icon (which looks like a small bar chart). Scroll down and check the box labeled 'Logarithmic scale'.

Set Base and Bounds

Ensure the Base is set to 10. Then, adjust the 'Minimum' bound to 0.1 and the 'Maximum' bound to 1000 to perfectly frame your required labels.

Scale Adjustment: Once applied, the axis will natively display the exact increments you requested: 0.1, 1, 10, 100, and 1000.

Solution 2

Use a Dummy Series for Arbitrary Labels

If your required values do not follow a perfect logarithmic base and you truly need custom labels, you can hide the default axis and use data labels from a hidden dummy series.

Data Visualization Made Easy

Create Advanced Scatter Charts with WPS Spreadsheet

WPS Office offers a powerful Spreadsheet application that easily handles complex charting needs, including scatter plots with customizable logarithmic axis scales, making data visualization straightforward.

1. Insert a Scatter Chart: Select your dataset in WPS Spreadsheet, navigate to the Insert tab, and choose Scatter Chart.
2. Access Axis Options: Double-click the Y-axis to reveal the Format Object pane on the right.
3. Apply Logarithmic Scale: Under Axis Options, tick the 'Logarithmic scale' checkbox and enter your desired minimum and maximum bounds.

100% format compatibility with Microsoft Excel (.xlsx) filesEasily format axes with custom logarithmic scales in just a few clicksFree, lightweight, and user-friendly interface for both Mac and Windows

microsoft office alternative - wps office

Frequently Asked Questions

Why can't I just type my own numbers into the Excel axis?

Excel calculates axis labels automatically based on the minimum bound, maximum bound, and major unit intervals to ensure data plots accurately to a mathematical scale. It does not natively allow replacing these scale markers with arbitrary text.

Does applying a logarithmic scale change my actual data?

No, a logarithmic scale only changes how the data is visually represented on the chart. It compresses exceptionally large values and expands smaller values, which is helpful for viewing data spread across multiple orders of magnitude without altering the underlying spreadsheet values.

How do I remove the extra minor gridlines that appear with a logarithmic scale?

Select your chart, click the 'Chart Elements' button (the plus icon next to the chart), hover over 'Gridlines', click the side arrow, and uncheck 'Primary Minor Horizontal' to clear up the background.

Excel & Data Problems