log chart minor gridline values at tick marks

  • Thread starter Thread starter ExcellerZero
  • Start date Start date
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
 
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

Similar Threads

Minor gridline values at tick marks - 2nd post 2
Gridlines & Tick marks 1
Excel Chart Scaling 1
Log scale and minor gridline labels 2
How to dynamically set the lower and upper limits of the axes scaleson a MS Access xy-chart 3
Creating a line chart with two X-axes!! 1
Major and minor gridlines on logarithmic axis excel 2007 7
x-axis scale changes 3

Back
Top