### How to insert X axis scale values next to axis and X axis grid lin

by **dnAyM2xhcnJ5** » Fri, 24 Jun 2005 23:16:02 GMT

I usually create charts with logarithmic scale on the X axis.
I find that using "Scatter" chart function allows this to be done easily.
The final chart inserts the grid ticks but does not insert X axis values (or
even grid lines).
Does anyone know the simple way to achieve what I want?

### RE: How to insert X axis scale values next to axis and X axis grid lin

by **QmFyYiBSLg** » Fri, 24 Jun 2005 23:26:02 GMT

What is the min/max value for your X axis? As I recall, only axis labels
are put only for each decade, and not for anything in the middle. (shows
0.1, doesn't show 0.2-0.9, shows 1). You can do that, but it requires some
additional work.

### RE: How to insert X axis scale values next to axis and X axis grid lin

by **Q29sbGluczMy** » Fri, 24 Jun 2005 23:45:13 GMT

Min is 10, max is 1000. major axis values of 10, 100, 1000 is desiredalong
with major grid lines.

### Similar Threads:

1.The scale on vertical axis equals to scale on vertical axis of ano

Hello,
I have a chart that displays 'before product implementation' scenario and
another one next to it that dispalys 'after product implementation'. The user
will have two countries to choose from so I have to leave the scale on auto
rather than fix it because the the countries have very different size
markets.
What I would like to do is to make the vertical scale of graph 1 equal to
the vertical scale of graph 2 so that I can show the impact of the product
more clearly. Is there a way to do this which doesn't involved fixing the
scales?
Many thanks in advance.
--
Johanna

2.How do I reference x-axis or y-axis scale values to a worksheet ce

I would like to have a chart's x-axis or y-axis scale values (min, max, major
unit, minor unit, etc) reference a data cell. This way I could manually
change the scaling of the graph from the worksheet or have it scale
automatically depending on the input data.
OR if anyone knows how to simply have excel equate the x-axis and y-axis
scales, that would be awesome too. (ie. if a box (therefore equal sides) was
drawn in a xy scatter graph, it would look like a box in the chart, not a
rectangle)
Thanks in advance

3.Need PivotChart x axis to cross Y axis at minimum Y axis value

I see an option to have x cross y at max y, but how can I say min y?

4.dual y-axis align grid, drop line to y axis, add-ins

1. Is there a way of scaling two y axis so that the grid lines intersect at
a specified integer on both axes, other than trial-and-error?
2. Other than drawing one, how would one drop a perpendicular line (s)from a
plotted line to the y axis?
3. Any recommendations for free and paid (please specify) add-ins for excel
2007 charts?
Thanks in a advance,
John (SAS programmer who must use excel)

5.x axis alignment w/pos-neg y axis scale

Excel defaults the alignment of the months to the center
of the chart ~ I would like to move them to the bottom of
the chart.

6. How to make Primary axis and Secondary X-axis have the same scale

7. Excel: secondary Y axes with log-scale X axis

8. Adding data on Axis Major Gridlines next to Category Axis Collums