Forum Discussion
Wenhao_Wu
Jul 28, 2021Copper Contributor
How to change x-axis in log format
Hi Team,
I want to change the x-axis in log format. When I change Y-axis in log format, there shows a checkbox for me to do this. while when I want to do same thing to x-axis. It does not show this box, which means excel 2019 does not allow me to do that. My colleague's older excel version is ok to do it. I am confused.
Y-axis
X-axis
-Wenhao
To make x-axis logarithmic you need to use scatter chart.
3 Replies
- SergeiBaklanDiamond Contributor
To make x-axis logarithmic you need to use scatter chart.
- Wenhao_WuCopper Contributor
SergeiBaklan Thank you for your help!!!!
- SergeiBaklanDiamond Contributor
Wenhao_Wu , you are welcome