C
Can Of Worms
I am stumped.
How do you tell a graph what data set to use as a category and what to use
as the series?
I want to be able to set Field 'a' to use as the categories, and Field 'b'
to use as the series, with field 'c' to use as the Y values for each
category/series combination.
I have a form which through user selection of fields and criteria, they can
create their own queries and view the resulting data-sets. I already have
limits placed on what combinations they can and can't view, to keep the data
sets from getting too confusing.
I want to give them the ability to view a graph based on the data set they
have. As it stands right now, the graph pulls it's rowsource from a query,
which i change the SQL statement to the user's generated SQL statement when
the user's criteria and field selection is detected as being graphable
clearly.
The problem is, the graph will only show 1 category, with the series being
the 2nd field values, labeled as the 1st field's respective names.
Looking at the underlying datasheet in design view, I can manipulate the
datasheet manually and I see that what I need to get more categories to
appear is to have each category it's own column in the dataset, and the
series names as the 1st column, with the Y values that match each in the
appropriate cell. The dataset that is generated from the criteria and field
selection doesn't have the information in this layout.
I am probably not making any sense now, since I can barely figure out how to
explain what I think i am trying to do.
Do I need to change how my dataset is generated to match the layout of the
datasheet of the chart? or is there a method that I can use to assign
category and series labels from values in fields in a dataset?
Another...
-Can of Worms
How do you tell a graph what data set to use as a category and what to use
as the series?
I want to be able to set Field 'a' to use as the categories, and Field 'b'
to use as the series, with field 'c' to use as the Y values for each
category/series combination.
I have a form which through user selection of fields and criteria, they can
create their own queries and view the resulting data-sets. I already have
limits placed on what combinations they can and can't view, to keep the data
sets from getting too confusing.
I want to give them the ability to view a graph based on the data set they
have. As it stands right now, the graph pulls it's rowsource from a query,
which i change the SQL statement to the user's generated SQL statement when
the user's criteria and field selection is detected as being graphable
clearly.
The problem is, the graph will only show 1 category, with the series being
the 2nd field values, labeled as the 1st field's respective names.
Looking at the underlying datasheet in design view, I can manipulate the
datasheet manually and I see that what I need to get more categories to
appear is to have each category it's own column in the dataset, and the
series names as the 1st column, with the Y values that match each in the
appropriate cell. The dataset that is generated from the criteria and field
selection doesn't have the information in this layout.
I am probably not making any sense now, since I can barely figure out how to
explain what I think i am trying to do.
Do I need to change how my dataset is generated to match the layout of the
datasheet of the chart? or is there a method that I can use to assign
category and series labels from values in fields in a dataset?
Another...
-Can of Worms