Home |
Search |
Today's Posts |
#1
|
|||
|
|||
View of x-axis values
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. |
#2
|
|||
|
|||
View of x-axis values
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
space between y axis and data points.. | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Graphing Reversing the Axis | Setting up and Configuration of Excel |