-
Solved: Variable chart parameters
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
-
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
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
I've reread your requirements and adjusted the code to change chart 2
Last edited by mdmackillop; 07-16-2006 at 10:47 PM.
Reason: Option buttons added
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules