Remember Me?

#1
January 5th 10, 03:14 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Jan 2010 Posts: 2
Minor gridline values at tick marks - 2nd post

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

#2
January 6th 10, 04:39 AM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Sep 2007 Posts: 61
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
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

#3
January 6th 10, 04:53 AM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Sep 2007 Posts: 61
Minor gridline values at tick marks - 2nd post

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.

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

"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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post ExcellerZero Excel Discussion (Misc queries) 1 January 6th 10 06:29 PM dgilbey Charts and Charting in Excel 2 June 12th 09 06:40 PM NevilleT Charts and Charting in Excel 5 February 16th 09 01:36 PM ofey New Users to Excel 5 November 21st 05 06:32 PM Pete Johannesen Charts and Charting in Excel 1 June 1st 05 04:23 PM

All times are GMT +1. The time now is 01:54 PM.