macro to make line graphs

G

Guest

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.
 
M

Markus Scheible

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
 
T

Tushar Mehta

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
 
G

Guest

good stuff. just did that and worked perfectly. now will check out putting
the code in a loop to print all 100 charts.
thanks.
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top