ExcelBanter - View of x-axis values

Excel builds log scales that start on one decade and end on another (a
decade being a power of ten: 0.1, 1, 10, 100000, etc.). Your points are
plotted at the point along the log scale where the log of their X values
would go. This is how value axes work: they do not put a tick where your
data is, they put a tick wherever a major axis unit is.

If you want to see your values across the X axis, and not the default
axis labels, double click the axis, and on the Patterns tab check None
for Axis Tick Labels. Then add a series to your chart that uses the same
X values, but uses the Y axis minimum for its Y values. This is an XY
series; double click on it and on the Patterns tab, choose a cross
(~plus sign) as the marker, and no lines. On the Data Labels tab, check
the Show Categories option (or Show Labels, depends on version and my
memory's flaky). Finally double click on a data label, and on the
Alignment tab, choose Below for Position.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

AhmtDY wrote:

In addition:
These values are not log of my values. Graph is true but values at x-axis
are wrong!

"AhmtDY" wrote:

In logarithmic x-axis, values of x-axis (e.g: 2 to 2500) are converted to 10,
100, 1000.
But I want to see the original values -not log of that values and to adjust
maximum and minimum of x-axis per that values -not log of that values.
Thanks.