User (Legacy) Posted July 28, 2000 Report Share Posted July 28, 2000 Juan, Thanks for the response. We are already using ORDER BY [] DESC because we are selecting TOP 10 values. We could nest the SQL statements and reorder the result of the first select ASC, but then, if a user switches the view to BAR then the rows are messed up again. So my question was: Can we test for Gallery = GANTT (Yes, I know how now) and then Reverse the X axis? Or do I need to test for Gantt and requery the recordset because the axis can't be reversed? Gary Juan Cegarra <JuanC@softwarefx.com> wrote in message news:DE0379D14694D211B4CE00609770710D05CD13@sftfx-221.wamnet.net... > The easiest way would be to order the SQL statement in ascending order > (ASC) if the type will be a gantt chart. > > Please post questions related to ChartFX IE at the CfxIE.* newsgroups. > > Regards, > > Juan Cegarra > Software FX, Inc. > http://support.softwarefx.com > > > -----Original Message----- > From: Gary Ray [ mailto:gray@state.ut.us] > Posted At: Thursday, July 27, 2000 12:41 PM > Posted To: General > Conversation: Reverse X Axis > Subject: Reverse X Axis > > > Hi All, > > I am relatively new to ChartFX IE, but need to figure something out. I > feed > a recordset to a bar graph sorted Descending so it looks like this: > * > * * > * * > * * * > * * * * > > When changing to a Gantt type the X axis flips at the origin so the > chart > looks like: > * > ** > **** > ***** > > We want to test if the type is Gantt, and if so Reverse the X Axis so > the > largest values are on the top. Any ideas? > -- > Gary Ray > Application Developer > DWS-LMI Software Development > > 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.