macro to make line graphs

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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?
Click to expand...

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
 
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
 
good stuff. just did that and worked perfectly. now will check out putting
the code in a loop to print all 100 charts.
thanks.
 
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
 
Back
Top