Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 5th 10, 03:14 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2010
Posts: 2
Default 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   Report Post  
Old January 6th 10, 04:39 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
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

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

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

"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



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
log chart minor gridline values at tick marks ExcellerZero Excel Discussion (Misc queries) 1 January 6th 10 06:29 PM
Log scale and minor gridline labels dgilbey Charts and Charting in Excel 2 June 12th 09 06:40 PM
minor gridline labels NevilleT Charts and Charting in Excel 5 February 16th 09 01:36 PM
Tick marks ofey New Users to Excel 5 November 21st 05 06:32 PM
How to include minor tick labels on logarithmic axes in charts 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.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017