koala
07-16-2006, 05:00 AM
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
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