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
 

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

Top