Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Logarithmic Excel Charts - Axis Manipulation

Status
Not open for further replies.

jkb17

Programmer
Nov 27, 2000
156
US
Hello,

I am charting data based on the logarithm of its values. I would like the y-axis, however, to display the data in its actual value. Reason being is that the logarithm displays the true moves over time of the data because a move 50 years ago was more significant then a similar move now. I watn the y-axis to display the actual values and not the logarithmic values.

Is this feasible in Excel?

Thanks in advance

Jim
 
Hi,

You can choose the SCALE for each axis by selecting the axis and formatting - Scale -- ONLY select log for the X axis.

Skip,

[glasses] [red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart! [tongue]


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top