+ Reply to Thread
Results 1 to 4 of 4

Dynamically set graph axis min/max levels

  1. #1
    Registered User
    Join Date
    01-24-2012
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    2

    Dynamically set graph axis min/max levels

    I created an excel file that provides a rotor balancing solution based on vibration data runs.
    It uses a graphical display similar to GPS signals to locate a receivers location.
    Essentially, it displays 4 circles on a polar plot.

    To show properly, the X and Y axis must have the same min/max, so I "fixed" the axis properties to -10/+10
    The problem is that if the user data is higher than "10", the user is then forced to manually change both X and Y axis accordingly to visually fit the circles on the graph.

    I was hoping there was a way to add a "slider" control that would dynamically change the X and Y axis bounds of the graph.
    Has anyone done something like this?

    Regards
    Jim P

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

    Re: Dynamically set graph axis min/max levels

    I would expect to start here (unless you decide to go with Tushar-Meta's preprogrammed add-in): https://peltiertech.com/link-excel-c...lues-in-cells/

    If the "slider" control is important, you can link a slider control to the cell's that you decide to use for the inputs.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

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

    Re: Dynamically set graph axis min/max levels

    A non macro approach is to use a dummy series that has the largest ABS value, recalc'd and plotted in each quadrant.
    This will then make the autoscaling the same in both x/y axis for both min/max values
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    01-24-2012
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Dynamically set graph axis min/max levels

    Thanks for your help
    I created a small macro to do exactly what I wanted (re-size graph based on a cell value)

+ 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: 1
    Last Post: 11-06-2019, 07:30 AM
  2. Replies: 4
    Last Post: 09-15-2019, 12:09 PM
  3. Dynamically scaled Graph Axis - Not working
    By dante051967 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2019, 05:01 PM
  4. Replies: 0
    Last Post: 01-23-2019, 05:25 PM
  5. Replies: 0
    Last Post: 06-13-2011, 11:11 AM
  6. Line graph:water tank levels
    By gwmbox in forum Excel General
    Replies: 3
    Last Post: 01-05-2011, 12:27 PM
  7. can I make the vertical axis the category axis in Excel line graph
    By power1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2006, 04:50 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