Though not as flexible as a user form, this will get you started:
http://peltiertech.com/Excel/Charts/ChartByControl.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Steve" wrote in message
...
Hi
I wonder if anyone can help...?
I'm compiling monthly visitor statistics for the last 8 financial
years and need to produce a graph where the user can choose up to 5 of
those years for comparison on a line graph. The problem is I'm not
sure how to create the interface (for want of a better word) to allow
the user to do this.
Would a pop-up form be workable, with, say, CheckBoxes for the
financial year to be included - and if so, how to I then use that to
ensure the line of data is used? Or is there a better (simpler) way?
I'd appreciate any advice.
Thanks
Steve