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
Last edited by Steph12; 10-31-2013 at 10:24 AM.
The number of rows and columns to use is zero. Charts don't like named ranges that have no size.
perhaps you meant this. from Toys!B19, offset no rows or columns. Return a range that is 1 row by result of COUNTA
=OFFSET(Toys!$B$19,0,0,1,COUNTA(Toys!$B$19:$CA$19))
yes that works great thanks.
How do I now make it rolling 12 months.
I have a formula but I don't think that it is right.
=OFFSET(Toys!$B$30,0,12,1,COUNTA(Toys!$30:$30)-12)
as its taking off the first 12 but gathering the rest of the data.
Thanks
=OFFSET(Toys!$B$30,0,COUNTA(Toys!$30:$30)-11,1,12)
It work however the chart isn't dynamic how do i get the chart to react to this formula.
Thanks
you need to post an example workbook so we can see exactly what you have
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks