+ Reply to Thread
Results 1 to 2 of 2

double logarithmic scale

  1. #1
    Registered User
    Join Date
    05-10-2018
    Location
    Poland
    MS-Off Ver
    2013
    Posts
    1

    double logarithmic scale

    Hi,

    Would anyone solve my problem? I would like to create in excel a graph for which the y-axis is on a double logarithmic scale, while the x-axis is one-time logarithmated. Below is an example of a chart that I would like to write in excel.



    Regards
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,926

    Re: double logarithmic scale

    Are you already familiar with building XY scatter charts in Excel? Basically, the approach to building a chart like this is to:

    1) Create scatter chart based on log(log(f(x)) for the Y values (computed somewhere in your spreadsheet) vs. x.
    2) Computing the values for a "dummy series" somewhere in the spreadsheet to be used as the Y axis values. Adding that to the chart.
    3) Custom labeling the dummy series.
    4) Formatting the X axis to use a logarithmic scale.

    The process is very similar to the one described here for a reciprocal axis: https://peltiertech.com/reciprocal-chart-axis-scale/
    He also uses the same technique to build a probability chart: https://peltiertech.com/Excel/Charts...lityChart.html

    The only difference I would expect from these tutorials is that, where you have 2013, you won't need the 3rd party addin to add the data labels, because this functionality was added native to Excel in 2013.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Logarithmic Scale
    By dr_phd1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2013, 12:13 PM
  2. Logarithmic Scale Scatter Plot
    By bluefoot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2011, 03:55 PM
  3. Double x axis with logarithmic scale in scatter graph
    By gpktm in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-31-2007, 02:57 PM
  4. Help on logarithmic scale
    By pj_raesh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-23-2006, 06:50 AM
  5. How do I plot chart with negative value using Logarithmic Scale ?
    By FTian in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-15-2006, 07:20 AM
  6. [SOLVED] In the x axis, logarithmic scale
    By Charles in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-20-2006, 01:20 PM
  7. logarithmic scale on x-axis
    By Daniel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-08-2006, 10:30 PM
  8. Logarithmic Scale - Tic Label Disappearance
    By howie1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-16-2005, 09:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1