Charts with variable data source

[Geordie]

Good Morning All

Firstly I would like to apologise for my lack of knowledge on Excel Charts

The problem I have is that the data range varies each time and this is based on the value of a variable in the VBA

Example

The data range could be

a15:a & max_line

where max_line = 41

so the data range

a15:a41

the problem is the value of max_line is always known but changes


Please help by pointing me in the right direction

Many Thanks in advance

[TMS]

Suggest you post a sample workbook with whatever code you have ... and some typical data. Ideally, mock up what you hope/expect to get out.


Regards, TMS

[Geordie]

Thanks Trevor i have attached a sample workbook

I will try and explain what I need

For the example in attached workbook

The value in RawData!D1 is 10 (this is changed by the user each time)

Chart X Axis is A15:A66
Chart Y Axis is C15:C66

but what I need is a15:a & max_line
c15:c & max_line

where max_line is a public variable in the VBA code

I hope this helps

PS
Password for VBA = 2729
Password for sheets = 1111

Thanks in advance

[TMS]

OK, please have a look at the updated example. I have included an explanation of the approach that I have taken.

I haven't changed your code. However, it should be a simple case of setting the range on the Raw Data sheet to the value of the Public variable max_line

As an example:

Please Login or Register  to view this content.

Regards, TMS

[Geordie]

Sorry Trevor I can see where you explained your approach in the attached file
Think I must be having a blond moment sorry?

[Geordie]

sorry wasnt opening the the correct file sorry
reading through it now