Multiple Graphs VBA
 

Hi
I am trying to create a macro which creates multiple scatter graphs from a
simple list where column A has the x axis value, column y has the y axis
value and column c has a lable which is the graph title. This list is sorted
on column c and whenever this value changes, a new graph in a new worksheet
is needed. I don't require a trendline - in fact I would like each chart to
have a pre-existing median line
Ed

Multiple Graphs VBA
 

I would think that you would need to update all graphs if the table changed
since you may be adding rows in the middle of the original table. Each graph
is linked to the source table and adding rows in the midle of the source
table would change all the graphs. It may be simplier of deleting all graphs
in the workbook and then re-adding all the graphs.

"Eddie" wrote:

Hi
I am trying to create a macro which creates multiple scatter graphs from a
simple list where column A has the x axis value, column y has the y axis
value and column c has a lable which is the graph title. This list is sorted
on column c and whenever this value changes, a new graph in a new worksheet
is needed. I don't require a trendline - in fact I would like each chart to
have a pre-existing median line
Ed