Here's how to link two or more Excel charts together for easy manipulation within a document or presentation.
Sometimes, do you need to have two or more Excel charts displayed together, or wish to paste a PowerPoint presentation or document together? Instead of printing and pasting each separately, you can group them and work with them as a single object.
Say you have two charts; you make the second one smaller and position it in the first chart's chart area. Follow these steps to group the two charts:
1. Open the worksheet that contains the two charts.
2. Select one chart.
3. Press [Shift] and click the second chart.
4. Right-click the combined selection.
5. Click Grouping and then click Group.
Now when you click one of the charts, you select both of the charts, and you can cut, copy, and paste them together. You can ungroup the charts by selecting Ungroup in the Grouping shortcut menu in step 5.
Miss a tip?
Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.
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.