+ Reply to Thread
Results 1 to 7 of 7

Excel 2007 : Custom second Y axis labels - unusual range

  1. #1
    Registered User
    Join Date
    04-06-2011
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    4

    Custom second Y axis labels - unusual range

    I have a data series with a max value of +0.788 and a minimum value of -0.823. I currently have these plotted on a second Y axis of a chart with data in a completely different rang on the primary Y axis. The X axis just carries the data series name and the Y axis are ploteed against this.

    Currently XL is plotting an axis with a minimum value of -1 to a maximum of +1, with mid point of zero and linear points in between. For most purposes this would be fine however I require the range to run from -0.1 to +0.1 with zero midpoint (non sequentially E.g.

    -0.1, -0.2, -0.3, -0.4, -0.5, -0.6, -0.7, -0.8, -0.9, 0, +0.9, +0.8, +0.7, +0.6, +0.5, +0.4, +0.3, +0.2, +0.1

    and obviously the relevant data plotted against these points on the axis.

    Have researched custom axis on the web and all rely on a logical (numerative seqence) anyone any ideas?

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Custom second Y axis labels - unusual range

    I think you'd have to fudge that by converting the real data into data matching the positions you want them to appear in on your faked axis (e.g. -0.9 would convert to -0.1), then you would need an additional dummy series of XY scatter to create the 'axis labels'. Jon Peltier has broadly similar examples on his web site for creating the axis labels and plotting fake data if you look at his broken axis demos, as does Andy Pope here.
    Last edited by romperstomper; 04-06-2011 at 11:15 AM.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    04-06-2011
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Custom second Y axis labels - unusual range

    Romper,

    Thanks for that, unfortunately that is the answer I was half expecting. I have seen peltiers site and can see the way to do this using that methodology. For me it may be an option but not the preffered as I am in an engineering environment where it would take two pages of documement to explain what i'd done and why to justify to third parties and validate the data remapping, as the third parties would have full access to the core spreadsheed and not just the charts.

    Never mind if it has to be, then it has to be. Another case of simple things made hard!

    Geof

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Custom second Y axis labels - unusual range

    I would have thought two pages of document would be needed to explain how that scale works, regardless of whether the charting package used to create it with or without work arounds.

    It appears to have no logical flow to it at all. Is this some special scale where smaller values are better and closer to positive ones?
    Cheers
    Andy
    www.andypope.info

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Custom second Y axis labels - unusual range

    Quote Originally Posted by geof_i View Post
    Another case of simple things made hard!
    Whilst that is true of many things in Excel, I think this is a case of a generic program not catering to a very unusual requirement. Perhaps you need MatLab or an engineering-specific program?

  6. #6
    Registered User
    Join Date
    04-06-2011
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Custom second Y axis labels - unusual range

    Andy,

    This relates to electrical Power Factor (PF) whereby unity is 0 and the power cunsumed leads or lags the voltage waveform by my data figures. PF figures are obtained from cos(theta) of the leading or lagging angle.

    Power in line with voltage gives a cos(theta) of 0 or cos(90 degrees) = 0 as the consumed power moves away from the voltage waveform this gives us increasing figures toward 0.1 / -0.1 e.g 10 degrees leading waveform = cos(10) = .984 . wavforms can be leading or lagging from 90 degrees ( cos(90)=0 ) and thus the midpoint of zero.

    Hope this helps (blurs) this issue.

    Geof

  7. #7
    Registered User
    Join Date
    04-06-2011
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Custom second Y axis labels - unusual range

    Romper,


    probably very true, my requirements do not conform to the norm, agreed.

    Must admit I do appreciate more than many themamouth tasks that microsoft take on with OS's and office packages etc. and in general they always come up with the goods.

    G

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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