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.

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

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.

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.

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.