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.

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.

Editor's Picks

Free Newsletters, In your Inbox