Graph Data (v2000)

Topic

New Reply

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!

Reply | Quote

Replies

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.

Reply | Quote

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

Reply | Quote

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.

Reply | Quote