+ Reply to Thread
Results 1 to 2 of 2

Dynamic y-Axis

  1. #1
    Registered User
    Join Date
    05-27-2013
    Location
    Ahmedabad
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Dynamic y-Axis

    Hello,

    I am making a line chart for four companies showing their expenditure ratio.

    I want y-axis value to be dynamic and if I want to change the series values, the y-axis should automatically take that change.

    So my question is can we set minimum y-axis value which is dynamic according to the data?

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Dynamic y-Axis

    Yes... you can have a "defined name powered with offset / count functions" to do this task for you.

    Upload a sample workbook and I would be happy to show this to you.


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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