View Single Post
  #2   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.charting,microsoft.public.excel.printing
Jon Peltier
 
Posts: n/a
Default How to print 15 embeded charts on two sheets at once?

You don't want data cells. Does that mean you want each chart printed on its
own page? This cannot be done without a macro. Do you instead want just the
portion of the worksheet with the charts to be printed, but not the portion
of the sheet with the data? Select the range containing the charts, and set
the print area (File menu Print Area Set Print Area. Repeat for the
other worksheet, then select both (click on one, ctrl+click on the other),
File Print, choose the Active Sheets option to print both sheets at once.

If you want a whole bunch of charts printed on separate pages, make each
into a chart sheet (Chart menu Location As Chart), then use the
ctrl+click trick above to select the ones you want, and print them.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Dmitry" wrote in message
...
Hello specialists!
How to print 15 embedded charts (without data cells) on two sheets at
once?
Best regards,
Dima
elete