Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
AhmtDY
 
Posts: n/a
Default 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   Report Post  
AhmtDY
 
Posts: n/a
Default 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   Report Post  
Jon Peltier
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
How do I make the Y axis in an excel chart the category axis? megnadoodle Charts and Charting in Excel 2 March 29th 05 09:27 AM
space between y axis and data points.. Dave R. Charts and Charting in Excel 3 January 8th 05 05:56 AM
Second X axis at top of chart? Phil Hageman Charts and Charting in Excel 1 December 29th 04 02:48 PM
Graphing Reversing the Axis Michael R Middleton Setting up and Configuration of Excel 0 November 30th 04 11:59 PM


All times are GMT +1. The time now is 05:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"