S
simon.stewart
Hi,
I am trying to create a dynamic scatter graph in Excel. I have a list
of 40 names each with roughly 30 columns of data corresponding to
each
name. What I would like to do is create a multi list box so I could
select about 9 or 10 names. Once these are selected, I would like to
select which columns of data I would like the graph to show (perhaps
by using tick boxes?), obviously this would be limited to 2 columns
of
data for the x and y axes.
So a simple example would be to select the name "Glencore" and the
Col
E (value 29) and Col J (Value 128) and to click a macro button to
plot
the name Glencore which has an x axis value of 29 and y axis of 128.
I have limited knowledge of vba and am better at manipulating them
and
reading them rather than creating them from scratch.
Can anybody help me on how to get started? Thank you,
Simon
I am trying to create a dynamic scatter graph in Excel. I have a list
of 40 names each with roughly 30 columns of data corresponding to
each
name. What I would like to do is create a multi list box so I could
select about 9 or 10 names. Once these are selected, I would like to
select which columns of data I would like the graph to show (perhaps
by using tick boxes?), obviously this would be limited to 2 columns
of
data for the x and y axes.
So a simple example would be to select the name "Glencore" and the
Col
E (value 29) and Col J (Value 128) and to click a macro button to
plot
the name Glencore which has an x axis value of 29 and y axis of 128.
I have limited knowledge of vba and am better at manipulating them
and
reading them rather than creating them from scratch.
Can anybody help me on how to get started? Thank you,
Simon