Convert X-Axis primary and secondry horizontal axise into log scale.

Question

Convert X-Axis primary and secondry horizontal axise into log scale.

Chaturvedi, Santosh 340

Hello --

In MS excel combo graph

I want to change the y-axis and x.axis into log scale.

Y.axis is log scale is comming--> Ok (see below)

But on X-axis it is log scale is not schown in format X- Axis bar. I want to change teh primary and secomdry log scale both in log scale, but logscale tab is not visible.(see below.

Please sugegst

User's image

0 comments

Answer accepted by question author

Aetherin 1,465 Independent Advisor

Hi @Chaturvedi, Santosh,

Thank you for the additional screenshot. You have completed the key part correctly.

What’s already working well is that you successfully converted Series1 to an XY (Scatter) chart. Because a Scatter chart uses numeric value axes for both the X and Y dimensions, Excel allows both axes to be formatted using a logarithmic scale.

Regarding why the X-axis for σx2 still cannot be set to a logarithmic scale, this behavior is actually expected and does not indicate a configuration mistake. The σx2 series is still defined as a standard Clustered Column series. Unlike a Scatter chart, a Clustered Column chart uses a Category Axis for its horizontal axis, and Category Axes do not support logarithmic scaling.

In your screenshot, the upper horizontal axis is the numeric Value Axis used by the Scatter series, while the lower horizontal axis is the Category Axis used by the Clustered Column series. Adding a secondary horizontal axis does not convert the Column series’ Category Axis into a numeric Value Axis. Therefore, the horizontal axis used by σx2 cannot be formatted logarithmically while σx2 remains a standard Clustered Column series.

To achieve a logarithmic X-axis for σx2, the recommended approach is to convert σx2 to an XY (Scatter) series as well. Doing so will provide σx2 with a numeric horizontal Value Axis that supports logarithmic scaling. You can follow the same conversion process that was used for Series1, confirm that the X and Y value ranges are assigned correctly, and then enable the Logarithmic scale option for the appropriate horizontal Value Axis.

If the two Scatter series are assigned to separate primary and secondary axis groups, make sure both horizontal Value Axes are displayed, and then format each axis separately.

Make sure all X-values are greater than zero, because a logarithmic axis cannot plot zero or negative values.

Note: After σx2 is converted to Scatter, it will no longer appear as a standard column series. Excel does not natively provide a true logarithmic horizontal Category Axis for a standard Clustered Column series. Retaining a column-like appearance would require a Scatter-based workaround. Therefore, converting both series to XY Scatter is the most straightforward solution when a true logarithmic X-axis is required.

If anything remains unclear or if you have any updates after trying the suggested steps, please feel free to get back to me. I'll be happy to continue helping and clarify further if needed.

Thank you for your time and patience.

Aetherin 1,465 Reputation points Independent Advisor

2026-09-08T08:05:22.1866667+00:00

Good day @Chaturvedi, Santosh,

Have you had a chance to check the replies provided? Any update would be appreciated.
Chaturvedi, Santosh 340 Reputation points

2026-09-08T08:08:29.8933333+00:00

Hello Madam -- I have implemented the proposed solution. It is working perfect !!

Have a nice day
Aetherin 1,465 Reputation points Independent Advisor

2026-09-08T08:11:31.36+00:00

Hi @Chaturvedi, Santosh,

Thank you for your reply. I'm glad to hear that the proposed solution worked.

If you found my reply helpful, please take a moment to click "Yes" below my answer. This helps highlight the solution and makes it easier for other community members who may encounter the same issue to find it.
Aetherin 1,465 Reputation points Independent Advisor

2026-09-09T17:32:56.61+00:00

Hi @Chaturvedi, Santosh, I hope this message finds you well.

This is my second follow-up. I truly want to ensure your experience is as smooth as possible. If your problem is still ongoing or if you have faced any new difficulties, please share more details about the current steps you are stuck on. I am here and happy to provide further help whenever you need it.

While waiting for your response, I will continue tracking other customer questions on the forum to ensure everyone receives timely support. If you have additional questions, please feel free to tag my name in your reply so I can assist you promptly and more personally.

Looking forward to hearing from you soon.
Chaturvedi, Santosh 340 Reputation points

2026-09-10T06:31:31.8933333+00:00

Hello Aetherin -- All the suggestion is included and it is working perfectl.

Thanks for your valuable suggestions
Aetherin 1,465 Reputation points Independent Advisor

2026-09-10T06:46:24.8866667+00:00

Good day @Chaturvedi, Santosh,

If you confirm the issue has been resolved and found my response useful, please kindly click "Yes" on my answer to mark it as the accepted solution.

Thank you again for your patience and cooperation and I hope to have the opportunity to assist you again in the future.

2 additional answers

Your answer

Aetherin 1,465 Reputation points Independent Advisor

2026-09-08T08:05:22.1866667+00:00

Good day @Chaturvedi, Santosh,

Have you had a chance to check the replies provided? Any update would be appreciated.
Chaturvedi, Santosh 340 Reputation points

2026-09-08T08:08:29.8933333+00:00

Hello Madam -- I have implemented the proposed solution. It is working perfect !!

Have a nice day
Aetherin 1,465 Reputation points Independent Advisor

2026-09-08T08:11:31.36+00:00

Hi @Chaturvedi, Santosh,

Thank you for your reply. I'm glad to hear that the proposed solution worked.

If you found my reply helpful, please take a moment to click "Yes" below my answer. This helps highlight the solution and makes it easier for other community members who may encounter the same issue to find it.
Aetherin 1,465 Reputation points Independent Advisor

2026-09-09T17:32:56.61+00:00

Hi @Chaturvedi, Santosh, I hope this message finds you well.

This is my second follow-up. I truly want to ensure your experience is as smooth as possible. If your problem is still ongoing or if you have faced any new difficulties, please share more details about the current steps you are stuck on. I am here and happy to provide further help whenever you need it.

While waiting for your response, I will continue tracking other customer questions on the forum to ensure everyone receives timely support. If you have additional questions, please feel free to tag my name in your reply so I can assist you promptly and more personally.

Looking forward to hearing from you soon.
Chaturvedi, Santosh 340 Reputation points

2026-09-10T06:31:31.8933333+00:00

Hello Aetherin -- All the suggestion is included and it is working perfectl.

Thanks for your valuable suggestions
Aetherin 1,465 Reputation points Independent Advisor

2026-09-10T06:46:24.8866667+00:00

Good day @Chaturvedi, Santosh,

If you confirm the issue has been resolved and found my response useful, please kindly click "Yes" on my answer to mark it as the accepted solution.

Thank you again for your patience and cooperation and I hope to have the opportunity to assist you again in the future.

Answer 1

Hi @Chaturvedi, Santosh,

Based on the information I was able to verify, this behavior is expected in Excel.

Standard Column and Line charts use a Category Axis for the horizontal (X) axis. A Category Axis is designed to display and arrange labels as discrete categories and does not support logarithmic scaling.

Microsoft documentation confirms that a horizontal Category Axis provides options such as Text axis, Date axis, label intervals, and category order, rather than numerical scaling options such as a logarithmic scale.

To use a logarithmic X-axis, the data must be plotted as an XY (Scatter) chart, which uses a numeric value axis for the horizontal axis. This is also the recommended and most reliable solution.To convert the chart:

Select the chart and go to Chart Design > Change Chart Type.
Select XY (Scatter) and click OK.

User's image

If necessary, go to Chart Design > Select Data and verify that each series uses the correct numeric ranges for Series X values and Series Y values.
Right-click the horizontal value axis and select Format Axis.
Under Axis Options, enable Logarithmic scale.

Make sure all X-values are greater than zero, as a logarithmic scale cannot plot zero or negative values.

For more information, see the following Microsoft documentation:

I hope this explanation clarifies why you're seeing this behavior and helps you move forward with a workable solution.

Please give these steps a try and let me know the outcome. If you have any questions or need further assistance, feel free to reply here and I'll be happy to help.

If the answer is helpful, please kindly click "Yes" button below. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Chaturvedi, Santosh 340

Hello -- I am using combo chart -- USing scatter and column chart

XY scatter shows log xy axis-->OK

But in Bar chart the x-axis is not showing log value. (see below) I want the both axis in log scacle--

Please advice..

User's image

0 comments