Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Graph Data (v2000)

    I have a chart reflecting dollar sales by month. How can I get the axis scale to take a best fit approach? For instance, if sales vary between $1 million and $2 milliom, how can the axis adjust automatically to range from $1 million to $2 million? If the next year sales vary between $500,000 and $750,000, I would like the axis to adjust to reflect this range. The chart currently adjusts for the maximum limit but always sets the minimum value = $0.
    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Graph Data (v2000)

    This requires non-trivial code. Before programming anything, you will have to think of suitable settings for the minimum value for the axis and also for the major unit (the distance between the primary grid lines) depending on the minimum and maximum value of the data. What if the minimum data value is $490,000? Depends on the maximum data value, doesn't it. You have some serious thinking to do.

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Royal Oak, Michigan, USA
    Posts
    255
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graph Data (v2000)

    Thanks Hans. I decided to allow the user to set the minimum using an entry table. I think that's the easiest approach.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •