Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple graphs | Excel Programming | |||
Updating multiple graphs in multiple worksheets at the same time | Excel Discussion (Misc queries) | |||
multiple graphs in excel | Excel Programming | |||
Multiple Graphs | Excel Discussion (Misc queries) | |||
How do I put multiple graphs on one axis? | Charts and Charting in Excel |