R2006 Posted February 22, 2007 Report Share Posted February 22, 2007 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. Quote Link to comment Share on other sites More sharing options...
Frank Posted February 23, 2007 Report Share Posted February 23, 2007 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; Quote Link to comment Share on other sites More sharing options...
R2006 Posted February 23, 2007 Author Report Share Posted February 23, 2007 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. Quote Link to comment Share on other sites More sharing options...
Frank Posted March 16, 2007 Report Share Posted March 16, 2007 It's been added to the "wish list" Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.