If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to put x axis values in the chart instead of x axis labels | Sinclair | Charts and Charting | 1 | June 21st, 2005 11:04 AM |
Non-Numeric values in X axis of a scatter chart | penasm | General Discussion | 1 | October 28th, 2004 05:44 PM |
Scatter Chart with non-numeric values on X axis | penasm | Charts and Charting | 1 | October 28th, 2004 05:37 PM |
Problems charting x axis values | mike | Charts and Charting | 1 | June 7th, 2004 06:15 PM |
Newbie: How to I reverse X and Y axis values? | Larry Woods | Charts and Charting | 3 | September 27th, 2003 05:16 AM |