Charts

Selecting what you want within a chart

When working with charts, you will get very different menu choices when you right-click in different places on the chart. It is not uncommon to have to experiment with right-clicking in several places before finding the menu you're looking for.
It is sometimes easier to use the Chart menu - which appears in your CommandBar at the top of the page when you click anywhere on a chart.

To select the entire chart, hold down the Ctrl key as you left-click anywhere on the chart.

Using charts in Excel 2007

Charts were completely redesigned in Excel 2007, and Excel 2007 charts have bugs and missing features that users take for granted in Excel 97-2003.

Until Microsoft resolves their chart bugs in a future release, the Gantt Chart, Standard Work Combination Sheet, and QFD charts have the following issue:

When rows are added, deleted, hidden, or unhidden - the chart needs to be manually re-aligned

How to manually re-align charts in Excel 2007

Click on a blank area inside the body of the chart,
so that the entire body of the chart becomes highlighted
(as shown)

Then to resize the chart...
drag one of the square handles (in the middle),
or one of the round circles (in each corner)

Training & Demos home page

All rights reserved. No portion of this website may be reproduced or distributed outside of licensed users without written permission.
See License Agreement to learn about cash rewards for reporting unauthorized piracy of Systems2win templates or training.

Tips for printing web pages (like this one)
Option 1) Print in landscape. Internet Explorer - File > Page Setup > Landscape.
Option 2) Print the web page as a PDF file, (which can then be easily printed). Training: How to download and use free PDF writing software
Important: Any document created using a Systems2win template that is distributed outside of your licensed usersmust be in a non-editable format, such as printed paper or a PDF

Upgrade to get latest templates and another year of free support and training. What's New?
Feedback Form to share your ideas for how to continuously improve your tools for continuous improvement
Contact Systems2win