Excel VBA (Userforms)

Hi Arjun

Thanks for getting in touch. After a little research it's not very easy to do this with a VBA userform. The code required would be very complex and prone to breaking.

If you have to program this with VBA, have a look at some of the excellent tutorials on Jon Peltier's site:

http://peltiertech.com/

You can also achieve similar results using Excel's filtering tools. Here's a useful tutorial:

http://chandoo.org/wp/2009/02/12/make-a-dynamic-chart-using-data-filters/

You might want to consider putting your data into a PivotChart if possible. This will enable you to add a Slicer with no programming, and users could then add and remove the series as much as they like.

If this feature is a deal-breaker for you, consider upgrading to Excel 2013. The exact feature you've described is available by default on all charts.

https://www.stl-training.co.uk/b/exceltraining/2013/05/excel-2013-charts/

Sorry that the answer isn't straightforward!

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector