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
That's a bit abstract, could you provide a sample file without sensitive information?
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.