ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Logarithmic Scale for the X-Axis (https://www.excelbanter.com/charts-charting-excel/231728-logarithmic-scale-x-axis.html)

Ed

Logarithmic Scale for the X-Axis
 
I am currently using Excel 2007 and need to make a semi-log scale with the
x-axis in log scale. I only see an option to make the y-axis logarithmic
under the format axis menu. Is there anyone that can help?

Thanks in advance.

Andy Pope

Logarithmic Scale for the X-Axis
 
Hi,

You need to use XY-Scatter chart type in order to have X axis using a Log
scale.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Ed" wrote in message
...
I am currently using Excel 2007 and need to make a semi-log scale with the
x-axis in log scale. I only see an option to make the y-axis logarithmic
under the format axis menu. Is there anyone that can help?

Thanks in advance.




All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com