Minor gridline values at tick marks - 2nd post

  • Thread starter Thread starter ExcellerZero
  • Start date Start date
E

ExcellerZero

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
 
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
 
Hi,

This is a continuation to my previous response to your post.
Format the alignment of the X-axis labels to 270 degrees, so that the
numbers (especially hundreds and thousands) will not overlap upon each other.

To answer your second question:
Click on your name in any of your posts. A pop-up window will show your
posting history. Click on "Recent Posts by this user" in the top right side
corner. It will show your recent posts.

Regards,
B. R. Ramachandran
 
Back
Top