Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi Everyone,
I'm struggling with a macro to automatically create about 200 line graphs. There are a variable number of datapoints in each graph. The data are all in one column separated by blank lines, like: 123 456 789 887 762 1 2 3 55 44 88 447 I'm new to macros and have tried recording a macro to see the code. The macro is fine for creating a single graph, but I don't know how to get it to automatically repeat this to create all the graphs, especially when there are a variable number of datapoints from one batch to the next of this spreadsheet. Can anyone suggest a solution? I would very much appreciate your help. Kindest regards, Julian :-) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create graphs of functions | Excel Worksheet Functions | |||
Automatic Updating of Graphs | Charts and Charting in Excel | |||
sorting data and automatic graphs | Charts and Charting in Excel | |||
Automatic Graphs/ Dynamic Graphs | Charts and Charting in Excel | |||
how to create automatic macro with if statement or similar | Excel Discussion (Misc queries) |