Asked by:

Plot Multiple series in one graph using vba

Question

Hi guy..In case you all haven't seen my previous thread about the same topic, i am posting this thread again as i need this code quite urgent. Thanks..

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? Thanks.