log chart minor gridline values at tick marks

E

ExcellerZero

I have an XY scatter graph with log10 scales on both axes. How can I display
the minor gridline values at the axes tick marks? Currently, the axes
display only the power of 10 values (.1, 1, 10, etc...)

Thanks
 
J

Jon Peltier

Excel does not allow for minor tick labels. However, you can add a dummy
XY series along each axis, with a point at each value where you want a
label. Hide the points (no line or marker) and add a data label that
shows the value. Position the label appropriately.

- Jon
 
Top