Printing multiple charts
 

My question is - i have multiple charts on the same worksheet. Is it
possible to print them on separate pages without selecting each one
individually?

Printing multiple charts
 

Hi,

Depending on you layout inserting page breaks may solve your problem.

Cheers
Andy

Edwina wrote:
My question is - i have multiple charts on the same worksheet. Is it
possible to print them on separate pages without selecting each one
individually?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Printing multiple charts
 

Hi Edwina,

Here is a possible workaround.

Go to ViewPage Break Preview
Select a range of cells and then right click on those cells and select 'set
print area"
Then select another group of cells and right click on those cells and select
'add to print area'. You can add as many as you liike and each area will
be called Page 1, Page 2 etc.

You can then place each graph on their own pages and print them out
by page number.

HTH
Martin


"Edwina" wrote in message
...
My question is - i have multiple charts on the same worksheet. Is it
possible to print them on separate pages without selecting each one
individually?

Printing multiple charts
 

Of course you can. Just insert pay breaks.

"Edwina" 写入消息
...
My question is - i have multiple charts on the same worksheet. Is it
possible to print them on separate pages without selecting each one
individually?

Printing multiple charts
 

Thanks to everyone who answered my query.. sometimes the most obvious just
isn't obvious until it's pointed out! Thanks again...:-)

"Jack Yin" wrote:

Of course you can. Just insert pay breaks.

"Edwina" 写入消息
...
My question is - i have multiple charts on the same worksheet. Is it
possible to print them on separate pages without selecting each one
individually?