Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
minor gridline labels | Charts and Charting in Excel | |||
log chart minor gridline values at tick marks | Excel Discussion (Misc queries) | |||
Log scale and minor gridline labels | Charts and Charting in Excel | |||
Tick marks | New Users to Excel | |||
How to include minor tick labels on logarithmic axes in charts | Charts and Charting in Excel |