Solved: Variable chart parameters

[koala]

Hi Forum,

Can someone show me how to have a drop down box so the user can select start and finsh points for a chart.

I have included a small example of what I want the final result to look like.

Basically I recieve a spreadsheet with up to 40,000 rows and 30 colums of data.

For this part, I only work on 3 columns,

Column B for X values
Column E for 1 series of data
Column G for the second data series.

The chart range is always defined by the X values, however the x values are not continuos cells, which causes me difficulty to name a range for a drop down box.

I do not always want to chart the whole 40,000 rows. I may only want to chart between a number of X values.

To show what I wish to achieve a small example is attached.

The example has two charts, one covering the complete range, and another covering a part range.

To achieve the part range I want the user to select the start and finsh points using a drop down box which will show the X values.

Hoping someone can assist with some code.

Cheers
Koala

[mdmackillop]

Have a look at the attached. I've only coded for Chart 1, as I'm sure you can manage the other one.
Regards
MD

Edit: attachment removed

[mdmackillop]

I've reread your requirements and adjusted the code to change chart 2

[koala]

Thank you for your help mdmackillop.

That solution works a treat.

As this is only a small part of a fairly large project I am working on I am sure I may need to call on your assistance again.

This forum sure has helped me learn alot

cheers
Koala