+ Reply to Thread
Results 1 to 3 of 3

Scaling 2 X-Axis

  1. #1
    Forum Contributor
    Join Date
    02-26-2012
    Location
    Ottawa, ON
    MS-Off Ver
    Excel 2007
    Posts
    129

    Scaling 2 X-Axis

    Hello,

    I need to create a plot displays leakage currents over temperature. What I would like is to have leakage current on 1 y-axis and on the first x-axis, have the primary x-axis displayed as q/kT (T is in Kelvins and q and k are constants) and the secondary x-axis displayed in Kelvins.

    I've been digging through some google searches and realized I need to plot two data sets, and have the second data set use the secondary y-axis and the secondary x-axis. I reversed the values of the secondary x-axis so that the highest temperature is on the left side and the lowest on the right to line up with the primary x-axis. However, there is still an offset. I'm sure this is because the primary axis is not stepping linearly since the temperature is in the denominator... Does anyone have any suggestions of how to fix this?

    I can't post my data, but here is a picture of what plot I have so far.

    scale axis.PNG

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,393

    Re: Scaling 2 X-Axis

    It looks like a basic reciprocal temperature axis situation. I think you will find that this approach (using a labeled dummy series for the second T axis) will be easier than using two complete data series: https://peltiertech.com/reciprocal-chart-axis-scale/ In Peltier's tutorial, he uses the dummy axis to replace the reciprocal temperature axis, but it should be easy to adapt to the situation where you want the q/kT and T axes to both be visible.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    02-26-2012
    Location
    Ottawa, ON
    MS-Off Ver
    Excel 2007
    Posts
    129

    Re: Scaling 2 X-Axis

    Thank you so much for this! I got it working

+ 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] Scaling Third Axis in Chart
    By Jefffey in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 06-14-2017, 09:02 PM
  2. HELP: Scaling of 3 axis chart
    By d247 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-17-2014, 11:11 AM
  3. Category axis scaling using VBA
    By jmatthew in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-18-2009, 12:35 PM
  4. Scaling the x-axis
    By MechE10 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-15-2007, 12:34 AM
  5. Chart X Axis Scaling
    By proton in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2006, 12:36 PM
  6. [SOLVED] Scaling x-axis with time
    By Callum in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-18-2006, 12:50 PM
  7. X-Axis scaling on graph
    By bob2 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-20-2005, 12:12 PM

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