Hi Guys,
I have a chart that has data that goes horizontally I want to make this dynamic however I have created a formula that doesn't work when I try and put it into my chart.
=OFFSET(Toys!$B$19,0,COUNTA(Toys!$B$19:$CA$19),0,0)
Is it that I'm using counta?
where am I going wrong please help :/
Thanks
Steph
Bookmarks