+ Reply to Thread
Results 1 to 4 of 4

Figuring out scales based on a % value

  1. #1
    Registered User
    Join Date
    07-24-2018
    Location
    California
    MS-Off Ver
    10
    Posts
    56

    Cool Figuring out scales based on a % value

    Hi!!

    So I have a question and I am trying to figure out how to word it best so that its hopefully possible.

    Here is my issue:

    I have a few charts like this:

    1.PNG

    And using the VBA code found here: https://exceloffthegrid.com/chart-axis-min-mix/ , I am able to scale my primary and secondary axes the way I want them to be scaled.

    The way I want the scaling to be done is the max value of the Light Blue shaded area to align with 100% from the primary axis

    When the max % is 100%, its super easy, all I have to do is set the scale for the max Secondary axis value to be the MAX value of the row in which this data comes from (shown in the first image) and the macro takes care of the rest.

    So my ask, and my issue, is how do I do this if the max % in the primary axis is over 100%? Example shown below:
    1.PNG

    What I did for this current snip was a whole bunch of guess-and-check plugging numbers into the Max Secondary axis and finally found the sweet spot that aligned the Light Blue with 100%

    If this is possible, I would prefer to have some function statement that figures that scale out automatically, so every month I don't have to go back and guess-and-check again.

    Does this make sense? I feel like there's probably a better way to explain but I cannot for the life of me figure it out, but anyways I am really hoping this is possible!

    Please let me know if you have any suggestions!!! Thank you so mcuh!
    Thank you!!!

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,621

    Re: Figuring out scales based on a % value

    Hi there,

    See if the following code gets you moving in the right direction:

    Please Login or Register  to view this content.
    The highlighted values may be altered to suit your requirements.

    iMASTER_SERIES is the Series Collection No of your "100%" series
    iSLAVE_SERIES is the Series Collection No of your "light blue" series


    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

  3. #3
    Registered User
    Join Date
    07-24-2018
    Location
    California
    MS-Off Ver
    10
    Posts
    56

    Re: Figuring out scales based on a % value

    Thank you so much!

    Apologies on the late response but I really appreciate the help

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2013
    Posts
    3,621

    Re: Figuring out scales based on a % value

    Hi again,

    Many thanks for your feedback and also for the Reputation increase - much appreciated!

    You're welcome - glad I was able to help.

    Best regards,

    Greg M

+ 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. Replies: 3
    Last Post: 07-18-2019, 11:16 AM
  2. [SOLVED] Looking to create subtotals based on size scales...
    By Bobbysmom 23 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-11-2015, 02:15 PM
  3. [SOLVED] Figuring out if you are late or not based on a start date
    By RJL3313 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-15-2015, 02:56 PM
  4. Replies: 0
    Last Post: 11-18-2013, 03:50 PM
  5. [SOLVED] Help figuring out $ in one column with conditions based on other columns
    By Alinkowski in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-30-2013, 05:12 PM
  6. Figuring a formula based on a cell value range
    By scottypete in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-04-2012, 11:10 AM
  7. Figuring a letter grade based on a %
    By mkingsley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-15-2008, 01:05 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