Filtering columns that appear in a chart

[yrpsoa]

Hi,

I'm trying to filter the columns that appear in a chart.

I've been through a number of methods to achieve this, but the most practical seems to be a named range using =filter(tranpose()) (and tranpose back if needs be), but what would I put in the filter argument? The cell references aren't valid anymore since it's been transposed. Don't know whether this makes it easier or harder, but the data I'm transposing is also a table...

An example would be the below, where I'd like to toggle dynamically between odd and even categories.

Person	Category 1	Category 2	Category 3	Category 4
Person A
Person B
Person C

something like: =filter(tranpose(table),if([tickbox]=TRUE,iseven(right(headers)*1),""))

What would the references be, once the columns become the rows??

(This isn't the actual scenario, but serves as a good proxy)

Hope this makes sense to someone!

Any help would be much appreciated!

Thanks!

 

[yrpsoa]

Solved, for anyone viewing this. You also have to transpose the headers eg/ filter(transpose(table),if([tickbox]=TRUE,iseven(right(headers))*1,""))