Display Multiple Charts On A Single Chart Sheet
An Excel chart can appear embedded in a worksheet or reside in a separate Chart sheet. Here's a trick for storing multiple charts on a single Chart sheet.
Create charts as usual, placing them in a worksheet. Select any blank cell in the worksheet and press F11; this creates an empty Chart sheet to hold the embedded charts. Reactivate your worksheet, click an embedded chart, and select Chart, Location to display the Chart Location dialog box. Choose "As object in" and specify the empty Chart sheet. Excel will transfer the embedded chart to your Chart sheet.
Select your remaining charts, and use Chart, Location to move them to the Chart sheet. Now you can arrange and size the charts any way you like. Putting multiple charts on a single Chart sheet lets you use the View, Sized with Window command (available when the Chart sheet is active) to scale the charts to the window size and dimensions.
Following is an example of a Chart sheet that contains three charts. When the window is resized, the charts adjust to fill the window automatically.
Excel has a long history, and it continues to evolve and change. Consequently, the tips provided here do not necessarily apply to all versions of Excel.
In particular, the user interface for Excel 2007 (and later), is vastly different from its predecessors. Therefore, the menu commands listed in older tips, will not correspond to the Excel 2007 (and later) user interface.
Browse Tips by Category
Search for Tips
Needs tips? Here are two books, with nothing but tips:
Contains more than 200 useful tips and tricks for Excel 2007 | Other Excel 2007 books | Amazon link: John Walkenbach's Favorite Excel 2007 Tips & Tricks