Combo Boxes as data source for a grapgh

[LuisE]

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 don’t find the concatenation of all 4 columns
any practical and besides, I don’t know how to incorporate the “all†to the
“sumif†other than several nested “if’sâ€
Any suggestions?

The headings of the data is as follows

Cntry- Plnt-Wrhse-Ctgry Week1 Week2 Week…………..

 

[Mark Ivey]

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

http://clem.mscd.edu/~mayest/FIN420...Controls/Using Controls to Change Charts.html


Mark Ivey

 

[LuisE]

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