Topic: Charts

The following are additional topics related to the category listed above. A bracketed number after the topic indicates how many articles are related to that subject.

Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Changing Chart Size Got a chart that isn’t quite the right size? Adjusting the size is just as easy as resizing any other graphic, as explained in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Changing Elements in Lots of Charts at One Time If you’ve got a workbook that has dozens of charts in it, you know that it can be a real pain to select each chart and make a common change (such as to a font) on each of them. This tip discusses different ways you can make simple changes to all the charts at once. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Deleting a Chart At some point you might want to delete a chart you previously created. How you go about the deletion depends on whether the chart was created as an embedded object or as a sheet. This tip explains how to remove both types of charts from a workbook. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Excel Charts in PowerPoint Do you regularly paste Excel charts into PowerPoint slides? Before you distribute that presentation to others, you may want to take a look at this tip. You’ll discover how to paste those charts without compromising accuracy, security, or file size. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Moving a Chart's Legend Need to move a chart legend to a different place on the chart? It’s easy to do using the mouse, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Positive and Negative Colors in a Chart When creating a line cart, the line can show values both positive and negative values. This tip explains how you can use different colors to display that portion of the line that dips below zero into negative territory. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Unlocking Charts Objects within a workbook are often locked as a form of protection. Your macro, however, may have a need to work with some of those locked objects. You’ll need the information in this tip so you can create the macro code necessary to unlock the objects. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Using Go To to Jump to a Chart Sheet Using Go To with a cell reference on a different worksheet is a great way of jumping somewhere. Using Go To with a chart sheet is impossible, however, because there are no cells on the sheet to reference. There are workarounds, however, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

More Topics

Tips, Tricks, and Answers

An Amazing Resource!

Helpful Links

Great Info!

RSS Feeds