Scaleable logrithmic Y axis

R

Rolls

Why isn't there an Excel feature that allows the Y axis to scale, and the
user to be able to select gridlines appropriately? For instance a data
range from 9.5 to 10.5 is only 1 unit but the chart displays a range from 1
to 100 when a logrithmic scale is selected.
 
T

Tushar Mehta

Yes, it is unfortunate that MS hasn't provided that capability. In the
meantime, if you are looking for a workaround, check the 'Flexible Log
Scale' page of my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I change the scale of logrithmic curve on the x-axis? 3
Formatting 'X' Axis -- 2 fundamental differences 7
Log scale and minor gridline labels 2
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
How to set scale of y axis for time 5
Data labels along below x axis when y axis has negative values 1
Help needed with multi y-axis chart 1
Overlaying 2 Data Series with Different Time (X) Axis 3

Top