Y1 & Y2 Max Value Settings

[R2006]

When we are building charts that use data labels above the bars, the system frequently selects a default yaxis max value that results in the labels being place outside the plot area.

If the bars are in the middle of the plot they well overlap with titles.

 

Is there a way to control/prevent this from happening without having to assume responsibility for calculating yaxis max values by ourselves?  It would be ideal if the Yaxis max was calculated to fit the bar + the font size for label with a little extra rom for spacing.

 

Your thoughts are appreciated. 

[Frank]

There is no one property that will achieve exactly what you are looking for.

You can change the Max of the chart without having to calculate it.

For example, after setting your data you can do:

chart.AxisY.Max = 1.1 * chart.AxisY.Max;

 

[R2006]

Unfortunately that does not help because we do not know when this happens other than to look at the output and see overlapping labels or labels outside the plot area. I guess it would be better to have more white space at the top of the plot than labels outside the plot.

We would like to add this feature to the enhancement list.

[Frank]

It's been added to the "wish list"