Forum Discussion
how to change the data series on a dynamic chart
I copied an Excel template which has data series and dynamic charts, the chart does not update according to what is selected from the drop down list
Data is changing dynamically, just the formula for that is
=IF(Chart_Filter="Qtr 1",TBL_Sales[Aug-19],IF(Chart_Filter="Qtr 2",TBL_Sales[Sep-19],IF(Chart_Filter="Qtr 3",TBL_Sales[Oct-19],IF(Chart_Filter="Qtr 4",TBL_Sales[Nov-19],IF(Chart_Filter="Total",TBL_Sales[Total],"")))))I guess in initial table headers were Q1, Q2, etc, now they are changed on months. If so, named formula is to be corrected in Name Manger.