I have 6 chart worksheets in a workbook. I would like to print them all on
one page. How can I do this?
Kind regards
I have 6 chart worksheets in a workbook. I would like to print them all on
one page. How can I do this?
Kind regards
Hi,
I don't believe you can print them on a single page. The fact they are
separate sheets means a new page will be used for each one.
You could move the charts to a single sheet by making each chartsheet an
object within a new empty chartsheet. To do this use the location method
on the chart to specify it's new location as an object within a chartsheet.
Or if your printer has the option you may be able to print multiple
pages on a single sheet.
Cheers
Andy
faberk wrote:
> I have 6 chart worksheets in a workbook. I would like to print them all on
> one page. How can I do this?
>
> Kind regards
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks