Mar 23 2022 01:54 AM
I need help on 2 problems. The first is my count if function is not working. It does not change the count even though my variable range changes. The count function is in cell H18 in the attached workbook. The other problem I have is that I am not able to resize my chart when move to a separate sheet.
Mar 23 2022 02:07 AM
@Liphor What do you mean? when I change the "Catch" slicer to another region the count changes with it. And so does the chart.
Mar 23 2022 02:13 AM
Mar 23 2022 02:16 AM
Mar 23 2022 02:18 AM
Mar 23 2022 02:23 AM
Mar 23 2022 02:30 AM
Mar 23 2022 02:37 AM
@Liphor Well, then don't move it into it's own (dedicated) sheet, but into another (regular) worksheet. For instance, a sheet called myCharts.
Mar 23 2022 02:53 AM
Mar 23 2022 02:56 AM
Mar 23 2022 02:57 AM
@Liphor See attached.