Place multiple charts on a chart sheet in Excel - TechRepublic
Software
SHARE
Facebook X Pinterest WhatsApp

Place multiple charts on a chart sheet in Excel

Did you know that you can put as many charts as you can fit on a chart sheet in Microsoft Excel? This tip walks you through the six simple steps for accomplishing this quick trick.

Written By
maryannrichardson
maryannrichardson
May 3, 2005
We may earn from vendors via affiliate links or sponsorships. This might affect product placement on our site, but not the content of our reviews. See our Terms of Use for details.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

You can place more than one chart on a chart sheet. For
example, let’s say you have two charts on two different worksheets, and you
want to put them both on a single chart sheet for comparison and printing.

Follow these steps:

  1. Click
    an empty cell, and press [F11].
  2. Change
    the default chart name to Two Chart Sheet.
  3. Select
    the first chart you want to move to the chart sheet, and go to Chart |
    Location.
  4. Select
    As Object In, and choose Two Chart Sheet from the drop-down list.
  5. Click
    OK.
  6. Repeat
    Steps 3 through 5 for the second chart you want to move.

You can move as many charts as you can fit. Go to View |
Sized With Window to scale the charts to the window.
maryannrichardson