Dynamic Chart Range

[gheyman]

I have been searching the net and reading a book to try and make a simply chart I have Dynamic using VBA.

I am trying to make it so that the chart changes if you add more data? For example if you start with 10 entries and then add another 5, I want the chart to reflect this.

I need it to adjust the number of columns in the chart. Sometimes the data in rows 103 and 104 go out to column F or sometimes it only goes to column D or it could be 10 months worth of data in the two rows and go out to column L

My chart is Chart 4 on a tab named Cash Flow

The current range of the chart is ='Cash Flow'!$B$101:$L$104

 

[DebugGalpin]

I have been searching the net and reading a book to try and make a simply chart I have Dynamic using VBA.

I am trying to make it so that the chart changes if you add more data? For example if you start with 10 entries and then add another 5, I want the chart to reflect this.

I need it to adjust the number of columns in the chart. Sometimes the data in rows 103 and 104 go out to column F or sometimes it only goes to column D or it could be 10 months worth of data in the two rows and go out to column L

My chart is Chart 4 on a tab named Cash Flow

The current range of the chart is ='Cash Flow'!$B$101:$L$104

Formulas > Name Manger > New

Name: DynamicChart
Refers to : =offset(Cashflow!$A$1,0,0,counta(A:A),count(1:1))

This basically counts how many rows there are and how many columns there are giving you a dynamic chart range:

So when making your chart just enter "Dynamic Chart" in the range field and it should pull up all the required data