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

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