X-axis Log Scale???

**txblitz27** · 03-18-2007, 09:33 PM

I have a lab report that's due in about a week that asks for the x-axis to be on a logarithmic scale. I've been on the internet and always find the same answer, double click the x-axis, go to the scale tab and check Logarithmic Scale. Excruciatingly easy, however when I go to do this there is no such checkbox when I go to the scale tab of formating the x-axis. Is there something I'm missing? I'm using Excel 2002 and have tried other computers and their version of Excel (currently on a campus computer with Excel 2003) and still no checkbox. Please Help!

**Paul** · 03-18-2007, 09:43 PM

The Y-axis has an option to use Logarithmic scaling, not the X-axis. Can you change your chart's setup so that the values currently residing on the X-axis are switched with the Y-axis (by rearranging your data or changing the 'series' values for the chart)?

**MrShorty** · 03-19-2007, 12:38 AM

What type of chart? I'm guessing you are using one of the "category" charts. An XY scatter chart (which uses a numeric X axis) will give you the option of using a logarithmic X-axis.