Plot multiple lines in one chart  
Author Message

PostPosted: Visual Basic for Applications (VBA), Plot multiple lines in one chart Top

I did a userform that allow user to choose, using option button, which graph user wants to plot and it will run a macro that plot that sepecific graph. If i want to improve it so that it can allow the user to choose more than one selections and the macro will plot multiple lines in just one chart. For example, normally we just plot one y-value vs one x-value; now i want the macro to plot more than one y-values vs one x-value by randomly choose any options the user likes.
I have thought of a stupid way which is record lots of macros that satisfy all combinations of choices. There must be a better way, isn't it

Microsoft ISV Community Center Forums2