I have a series of graphs that are charted off of a full P&L statement
from a drop down window, which shows a graph representing each line of
the P&L as a percentage to Total Revenue.

What I need is a way to print these graphs with one macro as apposed to
changing the drop down to show which graph you want,and then manually
printing it. Also, there a many blank lines on the P&L and i want to
avoid printing all of that Junk, how can i avoid doing this?


--
Browner
------------------------------------------------------------------------
Browner's Profile: http://www.excelforum.com/member.php...o&userid=33657
View this thread: http://www.excelforum.com/showthread...hreadid=543105

a loop


for each c in [mylist]
do your thing
next

--
Don Guillett
SalesAid Software

"Browner" wrote in
message ...

I have a series of graphs that are charted off of a full P&L statement
from a drop down window, which shows a graph representing each line of
the P&L as a percentage to Total Revenue.

What I need is a way to print these graphs with one macro as apposed to
changing the drop down to show which graph you want,and then manually
printing it. Also, there a many blank lines on the P&L and i want to
avoid printing all of that Junk, how can i avoid doing this?


--
Browner
------------------------------------------------------------------------
Browner's Profile:
http://www.excelforum.com/member.php...o&userid=33657
View this thread: http://www.excelforum.com/showthread...hreadid=543105

Don,
I don't know what you mean, can you ellaborate?


--
Browner
------------------------------------------------------------------------
Browner's Profile: http://www.excelforum.com/member.php...o&userid=33657
View this thread: http://www.excelforum.com/showthread...hreadid=543105

I assume that your drop down is a list somewhere. So a looping macro to
create the graph from the list as you are doing then print it. The macro
recorder may be your friend here giving you the idea of what is happening
when you create your graph and print it.

for each c in range("a2:a22")'[mylist]
create the graph
print the graph
next c ' do it for the next one in the list

--
Don Guillett
SalesAid Software

"Browner" wrote in
message ...

Don,
I don't know what you mean, can you ellaborate?


--
Browner
------------------------------------------------------------------------
Browner's Profile:
http://www.excelforum.com/member.php...o&userid=33657
View this thread: http://www.excelforum.com/showthread...hreadid=543105