Hello,
<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.
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.