| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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€¦€¦€¦€¦.. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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€¦€¦€¦€¦.. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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€¦€¦€¦€¦.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting Combo boxes to change options based on other Combo boxes. | New Users to Excel | |||
| Data validation on combo boxes | Excel Programming | |||
| Variable row data source for combo boxes? | Excel Programming | |||
| filling combo boxes from single outer source | Excel Discussion (Misc queries) | |||
| Combo Boxes for data entry | Excel Worksheet Functions | |||
Linear Mode
