Sorting on x-axis with a column clustered chart not sorting right

[gina]

I'm doing a query similar to as follows: I need to have Number of
Widgets on the y-axis, date of widgets on the x-axis, and the
different items in the legend would be the status of the widgets.
Well, in my query, I need to do a group by, this seems to may be the
cause if it messing up. In the group by, I am grouping by date
submitted, the item on the x-axis. When I do the query in a SQL
program, it orders the widgets in the correct order. But when I do
this on the web page (which is an ASP page written in VBscript if that
makes a difference), there doesn't seem to be any rhyme or reason to
how the values are sorted on the page. I can provide any type of
code, but since I am not sure what the problem is, I do not want to
post my whole page of script. Please let me know if you'd like to see
my code, sql, etc. Thanks!

 

[michael]

Hi Gina,
Please post a description of the table structure you are
pulling from(table names, column names, and how they are
related if more than one table is involved) and a brief
sample of how the results need to look...and your sql
statement that you have so far. Also, you may want to post
your question on (e-mail address removed) or
(e-mail address removed)...go to www.aspadvice.com. You might
find you have better luck there with sql and asp questions
since this list is for OWC component related questions. It
sounds like your problem shouldn't be too difficult to
resolve but without your query and an idea of how the
results need to be presented it is difficult to provide a
suggestion.
hth,
Michael

 

[gina]

hi -

ok i found the root of the problem. what's happening is regardless of
my query, which is grouping by date of widgets, then status, the chart
is grouping by status first, since it is in the legend, then the date,
since it is in the x-axis. is there a way with the OWC to be able to
sort by the x-axis, then legend seris?