MRichmond
02-12-2021, 03:06 AM
I'm looking for VBA help on a chart (well four actually). I have charts that look a bit messy, as they are made up from data from 6 locations. I wanted the user to be able to select one or multiple locations so they become a bit clearer. I've managed to record a macro that sort of does some of what I want (i.e. display a single location), but it doesnt work for me if I selected two locations. Could someone give me an idea how I can improve this please? Workbook attached.