+ Reply to Thread
Results 1 to 2 of 2

Changing Y-Axis of Excel chart to capture minimum and maximum values through a formula

  1. #1
    Registered User
    Join Date
    06-20-2016
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    1

    Changing Y-Axis of Excel chart to capture minimum and maximum values through a formula

    Hello,
    I have a set of data with x-axis being heads like indirect labour, salary labour, supplies, R&M, etc. and corresponding y-axis values as $25,000, 15,000, 10,000, 5000, etc.

    I wish to create an excel chart wherein I can make the y-axis to start from [min(y-axis) values *0.95].
    Because these values will keep on changing, whereas the x-values won't.

    Thus in the above case, for 4 values, instead of y-axis starting from 0, it should start from (5000*0.95 = 4750).
    I did read through this post : http://peltiertech.com/link-excel-ch...lues-in-cells/
    but could not figure out a way.

    Help appreciated!!

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

    Re: Changing Y-Axis of Excel chart to capture minimum and maximum values through a formula

    Jon's tutorial seems pretty straightforward to me. What specific part of his tutorial are you having trouble with? Entering suitable formulas into spreadsheet cells? Something in the code to change minimumscale and maximumscale properties? Getting the procedure to run as an event procedure? Were you able to set up Jon's tutorial sheet and chart exactly as he shows it, but could not adapt it to your specific spreadsheet? The solution to your problem is in Jon's tutorial, just figure out what part you are having trouble with.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Variable minimum and maximum axis values?
    By HalPlz in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 10-09-2015, 02:13 AM
  2. [SOLVED] Finding the minimum value of maximum values from multiple, changing worksheets
    By kwhelanne in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-05-2014, 05:17 AM
  3. [SOLVED] How to show chart maximum and minimum points label values
    By HerryMarkowitz in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-25-2014, 01:07 PM
  4. Replies: 2
    Last Post: 07-14-2014, 11:11 AM
  5. VBA to set Minimum and Maximum Values of X Axis
    By astha.malik1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2014, 04:42 AM
  6. linking maximum and minimum y axis values to a cell value
    By randor in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-15-2013, 08:12 PM
  7. Replies: 10
    Last Post: 10-07-2013, 11:41 AM

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