View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
B. R.Ramachandran B. R.Ramachandran is offline
external usenet poster
 
Posts: 61
Default Minor gridline values at tick marks - 2nd post

Hi,

There may be more elegant and straight-forward methods that I don't know.
But you can mimic what you want by adding two more series to your graph as
described below:

Assuming that the x- and y- axes are in the decades 0.1, 1,10, and 100
create two helper columns with the following data. For illustrative
purposes, let's say they are in the range A11:A38 and B11:B38
Enter 0.1 in all the cells in A11:A38.
In B11:B38, enter the values for the major and minor gridlines values for
the three decades. They are,
0.1, 0.2, 0.3, 0.4, 0.5, 0.6, 0.7, 0.8, 0.9, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0,
7.0, 8.0, 9.0, 10.0, 20.0, 30.0, 40.0, 50.0, 60.0, 70.0, 80.0, 90.0, 100.0

Add two new series to your graph. For one, make A11:A38 the x-values and
B11:B38 the y-values. For the other B11:B38 will be the x-values and A11:A38
will be the y-values. The markers for the two series will be on the x- and
y- axes. Right-click on a marker on the y-axis, "Add data labels". Right
click on one of those data labels, "Format data labels" -- Click "Y-value"
and "left".
Similarly, right-click on a marker on the x-axis, "Add data lables". Format
data lables -- Click "X-value" and "below".
Now format the two data series and set "Marker Options" to "None".

If this post helps, please give a feedback by clicking "Yes".

Regards,
B. R. Ramachandran


"ExcellerZero" wrote:

Couldn't find my earlier question on this matter.

I have an XY scatter graph with log10 axes. How do I display the minor
gridline values between the powers of 10 (between .1 and 1, between 1 and 10,
and so on)?

As an aside, how do I look for all my posts, especially if I don't recall
which Excel category in which it was posted?

Thanks