Results 1 to 19 of 19

Logarithmic Scale Base

Threaded View

soubasa Logarithmic Scale Base 09-23-2020, 03:47 PM
MrShorty Re: Logarithmic Scale Base 09-23-2020, 04:29 PM
soubasa Re: Logarithmic Scale Base 07-31-2022, 01:29 PM
swaatacba Re: Logarithmic Scale Base 08-01-2022, 02:38 AM
soubasa Re: Logarithmic Scale Base 08-01-2022, 03:08 AM
swaatacba Re: Logarithmic Scale Base 08-01-2022, 04:08 AM
soubasa Re: Logarithmic Scale Base 08-01-2022, 09:05 AM
MrShorty Re: Logarithmic Scale Base 08-01-2022, 09:29 AM
swaatacba Re: Logarithmic Scale Base 08-01-2022, 11:04 AM
MrShorty Re: Logarithmic Scale Base 08-01-2022, 05:25 PM
soubasa Logarithmic Scale Base 08-03-2022, 07:20 AM
Glenn Kennedy Re: Arithmetic Percentage... 08-03-2022, 07:24 AM
AliGW Re: Logarithmic Scale Base 08-03-2022, 07:59 AM
soubasa Re: Logarithmic Scale Base 08-03-2022, 08:45 AM
MrShorty Re: Logarithmic Scale Base 08-03-2022, 11:39 AM
soubasa Re: Logarithmic Scale Base 08-04-2022, 07:24 AM
MrShorty Re: Logarithmic Scale Base 08-04-2022, 10:39 AM
soubasa Re: Logarithmic Scale Base 08-04-2022, 03:04 PM
MrShorty Re: Logarithmic Scale Base 08-04-2022, 03:18 PM
  1. #8
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,436

    Re: Logarithmic Scale Base

    I won't be able to look at this closer until later. Are there specific parts of Peltier's tutorials that you have difficulty implementing? I would expect:

    1) In a convenient place in the spreadsheet, enter a column of 0s (X values for new, xy scatter data series), a column for the desired data label values, and a column with the desired logarithm of those values (LOG() function -- y values for new, xy scatter data series).
    2) Go into the Select data dialog and add a new data series, use the column of new y values for the values.
    3) Change this new data series to an xy scatter chart type (to create the line + xy scatter combination chart). Excel may automatically add secondary vertical and horizontal axes.
    4) From Select Data dialog, edit the new data series to use the correct x values for this data series (the column of 0s from step 1).
    5) Come up with a workable combination of scale on the secondary horizontal axis and value in the x values that correctly positions the xy scatter data series on top of the primary vertical axis.
    6) Add data labels (values from cells option) to the xy scatter data series and tell it to use the data label values column from step 1.
    Last edited by MrShorty; 08-01-2022 at 11:36 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. double logarithmic scale
    By khulak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2018, 09:04 AM
  2. [SOLVED] Logarithmic Scale
    By dr_phd1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-23-2013, 12:13 PM
  3. Logarithmic Scale Scatter Plot
    By bluefoot in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-04-2011, 03:55 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. In the x axis, logarithmic scale
    By Charles in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-20-2006, 01:20 PM
  6. [SOLVED] logarithmic scale on x-axis
    By Daniel in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-08-2006, 10:30 PM
  7. [SOLVED] Logarithmic Scale - Tic Label Disappearance
    By howie1 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-16-2005, 09:07 AM

Tags for this Thread

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