View Single Post
  #4   Report Post  
Andy Pope
 
Posts: n/a
Default

Double click the x axis. This should display the format dialog.
On the Scale tab is the option for Log scale (very similar to y axis
method).

Cheers
Andy

Doris wrote:
Where do I set log scale for x-axis on scatter plot

"Andy Pope" wrote:


Hi,

You need to use the xy scatter chart type if you want an x-axis log scale.

Cheers
Andy

Doris wrote:

how can I make a chart with the x-axis in logarithmic scale. the built in
function makes the y-axis log


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info