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€¦€¦€¦€¦..