I have a simple table of data in Excel that I would like to chart, but I would like to be able to select which columns to chart without having to edit the chart each time. For example I have data like this
Can I do this with some macros, or will I need to fool around in VB? And if VB as there any suggestions?
Thanks in advance.