# Dynamic Chart Vertically

1. ## Dynamic Chart Vertically

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?

Thanks

Steph

2. ## Re: Dynamic Chart Vertically

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))

3. ## Re: Dynamic Chart Vertically

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

4. ## Re: Dynamic Chart Vertically

=OFFSET(Toys!\$B\$30,0,COUNTA(Toys!\$30:\$30)-11,1,12)

5. ## Re: Dynamic Chart Vertically

It work however the chart isn't dynamic how do i get the chart to react to this formula.

Thanks

6. ## Re: Dynamic Chart Vertically

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)