Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default log chart minor gridline values at tick marks

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 461
Default log chart minor gridline values at tick marks

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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



ExcellerZero wrote:
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
minor gridline labels NevilleT Charts and Charting in Excel 6 May 5th 23 03:44 AM
Log scale and minor gridline labels dgilbey Charts and Charting in Excel 2 June 12th 09 06:40 PM
bar chart prints 1 unwanted horizontal row of dots & tick marks? daf Charts and Charting in Excel 0 November 11th 08 08:09 PM
Y-axis tick marks in middle of chart? Ed Charts and Charting in Excel 6 May 26th 05 01:16 PM
tick marks on all 4 sides of an x-y chart mickey Charts and Charting in Excel 1 May 2nd 05 11:09 AM


All times are GMT +1. The time now is 09:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"