Combo Boxes as data source for a grapgh
 

I want to graph the totals by week by combination of unique values from the
first four columns. For that I created 4 combo-boxes (not in a form), each
one containing all the possible unique records on that column, I also
included an €œall€� item in each list for those cases where the user wants to
see €œtotals€� of all columns or certain combinations.
The idea is similar to a pivot table. I concatenated two fields (columns)
and graphed them by using €œsumif€� now the user is asking for more
€œquery/filter€�options but I dont find the concatenation of all 4 columns
any practical and besides, I dont know how to incorporate the €œall€� to the
€œsumif€� other than several nested €œifs€�
Any suggestions?

The headings of the data is as follows

Cntry- Plnt-Wrhse-Ctgry Week1 Week2 Week€¦€¦€¦€¦..

Combo Boxes as data source for a grapgh
 

See if this link may shed some light on what you want to do...

http://clem.mscd.edu/~mayest/FIN4200...%20Charts.html


Mark Ivey



"LuisE" wrote in message
...
I want to graph the totals by week by combination of unique values from
the
first four columns. For that I created 4 combo-boxes (not in a form), each
one containing all the possible unique records on that column, I also
included an €œall€� item in each list for those cases where the user wants
to
see €œtotals€� of all columns or certain combinations.
The idea is similar to a pivot table. I concatenated two fields (columns)
and graphed them by using €œsumif€� now the user is asking for more
€œquery/filter€�options but I dont find the concatenation of all 4 columns
any practical and besides, I dont know how to incorporate the €œall€� to
the
€œsumif€� other than several nested €œifs€�
Any suggestions?

The headings of the data is as follows

Cntry- Plnt-Wrhse-Ctgry Week1 Week2 Week€¦€¦€¦€¦..

Combo Boxes as data source for a grapgh
 

Thanks. I ended up using DSUM in an avery similar approach.

"Mark Ivey" wrote:

See if this link may shed some light on what you want to do...

http://clem.mscd.edu/~mayest/FIN4200...%20Charts.html


Mark Ivey



"LuisE" wrote in message
...
I want to graph the totals by week by combination of unique values from
the
first four columns. For that I created 4 combo-boxes (not in a form), each
one containing all the possible unique records on that column, I also
included an €œall€� item in each list for those cases where the user wants
to
see €œtotals€� of all columns or certain combinations.
The idea is similar to a pivot table. I concatenated two fields (columns)
and graphed them by using €œsumif€� now the user is asking for more
€œquery/filter€�options but I dont find the concatenation of all 4 columns
any practical and besides, I dont know how to incorporate the €œall€� to
the
€œsumif€� other than several nested €œifs€�
Any suggestions?

The headings of the data is as follows

Cntry- Plnt-Wrhse-Ctgry Week1 Week2 Week€¦€¦€¦€¦..