Offset to return selected columns

[Oredo]

Hello,

a

b

c

d

<tbody>
</tbody>

it represents my pivot headers (categories) and i want to use offset function to retrieve just chosen columns to show on chart?


=OFFSET(A1,0,0,COUNTIF(A1:A10,"<>"),1) is working well with rows, but what should i use to get array of columns?

I can't use pivotchart as i can't get scatter plot with pivot table, and i would love it to be dynamic.