View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
MartinW[_3_] MartinW[_3_] is offline
external usenet poster
 
Posts: 41
Default 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?