Home |
Search |
Today's Posts |
#1
|
|||
|
|||
macro to make line graphs
is there a macro available to grab data from 3 columns, make 3 corresponding
lines on a graph and then print the graph? if so; is there a macro to do the above 100 times... that is; end up printing 100 pages automatically, with one graph on each page, consisting of the 3 lines on each graph? much appreciated. |
#2
|
|||
|
|||
Hi unknown,
afaik there is no macro that does that.... unless you write one yourself ;o) is there a macro available to grab data from 3 columns, make 3 corresponding lines on a graph and then print the graph? if so; is there a macro to do the above 100 times... that is; end up printing 100 pages automatically, with one graph on each page, consisting of the 3 lines on each graph? You could also do that, depending where you data columns are, if they vary in length a.s.o. Could you be a bit more precise, please? Best Markus |
#3
|
|||
|
|||
Turn on the macro recorder (Tools | Macro Record new macro...), create
the desired chart, print it and turn off the recorder. Switch to the VBE and XL will give you the code. Share that code as well as an explanation of how the 100 charts differ from one another and someone should be able to customize the code for you. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , WSIB1 @discussions.microsoft.com says... is there a macro available to grab data from 3 columns, make 3 corresponding lines on a graph and then print the graph? if so; is there a macro to do the above 100 times... that is; end up printing 100 pages automatically, with one graph on each page, consisting of the 3 lines on each graph? much appreciated. |
#4
|
|||
|
|||
good stuff. just did that and worked perfectly. now will check out putting
the code in a loop to print all 100 charts. thanks. "Tushar Mehta" wrote: Turn on the macro recorder (Tools | Macro Record new macro...), create the desired chart, print it and turn off the recorder. Switch to the VBE and XL will give you the code. Share that code as well as an explanation of how the 100 charts differ from one another and someone should be able to customize the code for you. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , WSIB1 @discussions.microsoft.com says... is there a macro available to grab data from 3 columns, make 3 corresponding lines on a graph and then print the graph? if so; is there a macro to do the above 100 times... that is; end up printing 100 pages automatically, with one graph on each page, consisting of the 3 lines on each graph? much appreciated. |
#5
|
|||
|
|||
Good that worked out. If you need help converting the code into a loop
structure, you know where to post... {grin} -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , WSIB1 @discussions.microsoft.com says... good stuff. just did that and worked perfectly. now will check out putting the code in a loop to print all 100 charts. thanks. "Tushar Mehta" wrote: Turn on the macro recorder (Tools | Macro Record new macro...), create the desired chart, print it and turn off the recorder. Switch to the VBE and XL will give you the code. Share that code as well as an explanation of how the 100 charts differ from one another and someone should be able to customize the code for you. -- Regards, Tushar Mehta www.tushar-mehta.com Multi-disciplinary business expertise + Technology skills = Optimal solution to your business problem Recipient Microsoft MVP award 2000-2005 In article , WSIB1 @discussions.microsoft.com says... is there a macro available to grab data from 3 columns, make 3 corresponding lines on a graph and then print the graph? if so; is there a macro to do the above 100 times... that is; end up printing 100 pages automatically, with one graph on each page, consisting of the 3 lines on each graph? much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a section of a chart line dotted? | Charts and Charting in Excel | |||
How do I make a section of a chart line dotted? | Charts and Charting in Excel | |||
Make a macro of keystrokes. ie. F2,Shift & Home & right cursor,de. | Excel Worksheet Functions | |||
Macro - Skipping a line | Excel Worksheet Functions | |||
Line Graphs and Bar Graphs | Excel Discussion (Misc queries) |