Data for Graphs

[Steve]

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

 

[Jon Peltier]

Though not as flexible as a user form, this will get you started:

http://peltiertech.com/Excel/Charts/ChartByControl.html

- Jon

 

[Steve]

Though not as flexible as a user form, this will get you started:

http://peltiertech.com/Excel/Charts/ChartByControl.html

That did _exactly_ what I wanted. Thank you!

Steve