Spent half a day on this. Hoping half an hour on this board can help solve my problem.
I have a range of data (-2 to 2) gathered from a survey which I am using to create charts for my 5 potential responses in a 100% stacked column
chart. This currently works by using the COUNTIF function for the total range but I would like for the chart to recalculate depending on the filtered data of the demographic information I captured (e.g.: data filtered to only show male responses would create a new chart with only the respondent data for males)
Can this be done? I tried to use =SUMPRODUCT((A2:A10000="x")*SUBTOTAL(3,OFFSET(A2,ROW(A2:A10000)-ROW(A2),0)))
which others had posted as a solution to this issue but I think it only works when the data value is text and not numerical, as in my case.
Thoughts?
G
I have a range of data (-2 to 2) gathered from a survey which I am using to create charts for my 5 potential responses in a 100% stacked column
chart. This currently works by using the COUNTIF function for the total range but I would like for the chart to recalculate depending on the filtered data of the demographic information I captured (e.g.: data filtered to only show male responses would create a new chart with only the respondent data for males)
Can this be done? I tried to use =SUMPRODUCT((A2:A10000="x")*SUBTOTAL(3,OFFSET(A2,ROW(A2:A10000)-ROW(A2),0)))
which others had posted as a solution to this issue but I think it only works when the data value is text and not numerical, as in my case.
Thoughts?
G