Combined charts and cascading lists
fleur
-
fleur -
fleur -
Hello,
I want to create a chart from filtered data (multiple filters) by the user.
I tried using dropdown lists (form controls) but I can't link the data between the combo boxes.
I can only create some cascading lists with dropdowns and data validation (Indirect).
How can I create multiple linked lists based on 4 or 5 criteria?
Is it possible to select multiple data points for the same criterion? What should I use?
In the chart (stacked histogram), I can't add one or more non-stacked histograms to the right side of the plotting area.
How can I combine two types of charts?
The link to my file: http://www.cjoint.com/c/EFBbmOUHlRf
Thank you for your feedback.
I want to create a chart from filtered data (multiple filters) by the user.
I tried using dropdown lists (form controls) but I can't link the data between the combo boxes.
I can only create some cascading lists with dropdowns and data validation (Indirect).
How can I create multiple linked lists based on 4 or 5 criteria?
Is it possible to select multiple data points for the same criterion? What should I use?
In the chart (stacked histogram), I can't add one or more non-stacked histograms to the right side of the plotting area.
How can I combine two types of charts?
The link to my file: http://www.cjoint.com/c/EFBbmOUHlRf
Thank you for your feedback.
4 answers
-
Good evening,
Clarification on my request: it only concerns the creation of dropdown lists for the cascade chart (4 levels), with 2 multiple-choice lists.
Is the solution to use Listbox for the multiple-choice lists?
Do you know any links or examples that correspond to these cascading lists?
Best regards
