+ Reply to Thread
Results 1 to 2 of 2

How do I increase the plot area over a number of pages?

  1. #1
    richa
    Guest

    How do I increase the plot area over a number of pages?

    I would like to have a chart that extends across a number of pages
    horizontally and vertically.

    I can split up the data values to fake it horizontally, but I don't see any
    way to do this vertically.

    Is there any way to do this?
    TIA

  2. #2
    Tushar Mehta
    Guest

    Re: How do I increase the plot area over a number of pages?

    You can do this with a chart embedded in a worksheet.

    Click the chart. Drag the handles in the horizontal and vertical
    direction as desired. [You may want to set the zoom to 50% or even 25%
    before doing the dragging.]

    Now, select the cells behind the chart. The easiest way to do this is
    select the cell at the top-left corner, then SHIFT+click the cell as
    the bottom-right corner.

    Select File | Page Setup... | In the Page tab ensure that 'Adjust to
    100% normal size' is selected.

    Select File | Print... Make sure that in the 'Print What' section you
    select 'Selection'. Click Preview to preview the effect. You may want
    to fiddle with margins for maximum visual effect. Print when you are
    satisfied with the result.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>,
    [email protected] says...
    > I would like to have a chart that extends across a number of pages
    > horizontally and vertically.
    >
    > I can split up the data values to fake it horizontally, but I don't see any
    > way to do this vertically.
    >
    > Is there any way to do this?
    > TIA
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1