How to Determine Chart Maximum Scale (Auto)

Given that dual y-axis charts aren't yet possible, I'm very close to having Pareto Charts created (column & line w/data labels), however, scaling the Y-axis of the 2nd series (the cumulative percent line) is turing out to be tricky. It could be solved by finding an answer to either question below:
1. Is it possible to programatically set the chart y-axis Maximum Scale? (Or use a formula?)
2. What is the internal formula used to determine the Maximum Chart scale when it is left blank (automaticaly calculated)? (I could then similarly scale the plotted data values for the "line" series.)
Any other options?
Paul Cormier#1:
Right now you can only use constants for Min, Max, CrossAt, MajorInterval,
and MinorInterval. Therefore, you cannot calculate the maximum value in the
chart using a formula. This feature will be available in the next release
(RS 2005).
The right-side vertical axis of a pareto chart is the cumulative percentage
(typically from 0% to 100%). Presumably you use a backgroundimage on the
chart to "draw" the second y-axis in the plotarea (therefore size changes in
the plotarea will automatically "scale" the second y-axis). So, you don't
really need to dynamically specify the maximum of the y-axis, do you?
#2:
The Dundas chart control uses different formulas depending on the y-axis
margin setting.
Margin=False: y-axis maximum = Max(y-values of all datapoints)
Margin=True: y-axis maximum is rounded to the next higher "nice" number
depending on many factors (e.g. MajorInterval setting)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"WinCorp [cormip]" <WinCorp [cormip]@.discussions.microsoft.com> wrote in
message news:1DE93106-9B0F-4009-82B3-9AD6B2E39073@.microsoft.com...
> Given that dual y-axis charts aren't yet possible, I'm very close to
having Pareto Charts created (column & line w/data labels), however, scaling
the Y-axis of the 2nd series (the cumulative percent line) is turing out to
be tricky. It could be solved by finding an answer to either question below:
> 1. Is it possible to programatically set the chart y-axis Maximum Scale?
(Or use a formula?)
> 2. What is the internal formula used to determine the Maximum Chart scale
when it is left blank (automaticaly calculated)? (I could then similarly
scale the plotted data values for the "line" series.)
> Any other options?
> Paul Cormier