User (Legacy) Posted September 3, 2002 Report Share Posted September 3, 2002 We've found the following problem: If you have a bar chart (horizontal or vertical), and all values are negative and all values are the same, the chart it very un-useful. For example, if you have 3 values for the bar chart whose numeric values are: -1500.0 -1500.0 -1500.0 The bar chart you get is pretty useless. Contrast this with what you get when they are all positive 1500... Thanks, Marc Link to comment Share on other sites More sharing options...
Software FX Posted September 4, 2002 Report Share Posted September 4, 2002 To workaround this issue you could add this code after you pass the data If (chart.Axis(AXIS_Y).Max < 0) Then chart.Axis(AXIS_Y).Max = 0 ' This gives you half of the chart area but it may look nicer in a 2D chart ' chart.Axis(AXIS_Y).Max = -chart.Axis(AXIS_Y).Min End If -- Regards, JC Software FX Support "The Nomad" <nobody@nowhere.com> wrote in message news:VBmRS04UCHA.1288@webserver1.softwarefx.com... > We've found the following problem: > > If you have a bar chart (horizontal or vertical), and all values are > negative and all values are the same, the chart it very un-useful. > > For example, if you have 3 values for the bar chart whose numeric values > are: > > -1500.0 > -1500.0 > -1500.0 > > The bar chart you get is pretty useless. Contrast this with what you get > when they are all positive 1500... > > Thanks, > > Marc > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.