Posted 9 September 2017, 8:31 am ESTC1 Chart should updated on Check box and DroupDown Filters.
Here is the scenario for my chart.
I have Budget data to be shown on chart. At first, i am showing all the data as Month wise. i.e., month on X axis and currency on Y axis.
Now, i have drop down list for the department where i have sales, development, production, etc and check boxes for the period where the values are like yearly, quarterly, monthly, etc.
So When i choose department as sales, the chart data should show that department’s budget. (Here is another question, can we put all data series on the chart and as per the drop down value changes, we show/hide the data series column on the chart?)
And same with the check box also.
If this is not sufficient for the solution then let me know and thanks again for the valuable response.