vba excel charting by selection
Posted on 2011-09-27
Looking to do a new project with charting monthly performance numbers. Data is pretty straightforward, each trader has its own column, each row is a new months performance.
I was thinking of having a userform, where you can click on multiple traders names, and by doing so, will populate a chart with the data of the trader I selected.
Just looking for some ideas, possible better than what I'm thinking already.
Would you have a chart already made.. and the selections change the populating, or would you use the selection to create a new chart using vba everytime I run?
suggestions or thoughts?