+ Reply to Thread
Results 1 to 2 of 2

Dynamic Setting for Chart Axis Minimum

Hybrid View

  1. #1
    Registered User
    Join Date
    09-01-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Dynamic Setting for Chart Axis Minimum

    I am trying to make a dynamic chart which plots stock prices dynamically. I use Excel 2010 but this also happens in 2007

    My problem is:

    when my dataset gets past more than 212 points, excel's default min value for the chart goes to 0. If it uses 212 points or below I get no problem. I need to be able to make a 260 dataset into a chart BUT with these restrictions:

    1. It must not be VBA since I will be giving this program to people not used to it. the VBA thing will cause problems when deleting the chart. (and the macro notice makes some of my colleagues panic, 3 out of every 5 people in my institution call me on how to fix it)

    2. The 260 dataset is non-negotiable (I actually need double, but had that negotiated down)

    3. No password protection

    Thanks in advance to whoever can help me on this
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    09-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    216

    Re: Dynamic Setting for Chart Axis Minimum

    Unfortunately with Excel, you will be limited to their algorythm for calculating the Vertical Minimum without VBA.

    However, I would point out a few things.

    Anytime you manipulate the Vertical Axis minimum above 0, you can make the data show a trend that may not really be there. For example, if you change the chart minimum from your sample to 120, you will skew the data and stretch it more than at 110. I would recommend against it.

    So you may want to revisit what you are trying to show and if it is a small data range tolerances from 120 to 145, then perhaps you can fix the axis if VBA won't be creating the chart anyway and it sounds like users wont be creating the chart either.

    Just my thoughts. Good luck!

    Steve=True
    Last edited by teylyn; 09-20-2011 at 07:40 PM. Reason: removed url

+ 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