Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
minor gridline labels | Charts and Charting in Excel | |||
Log scale and minor gridline labels | Charts and Charting in Excel | |||
bar chart prints 1 unwanted horizontal row of dots & tick marks? | Charts and Charting in Excel | |||
Y-axis tick marks in middle of chart? | Charts and Charting in Excel | |||
tick marks on all 4 sides of an x-y chart | Charts and Charting in Excel |