There is filter of dimension and variable in the sheet. based on the combination of selection, i need to change chart type also for eg.
if i select demographics in dimension filter and age in variable, the chart type should be bar, if it is gender in variable, the chart type should be pie. need an urgent help please. attach is the workbook for reference.