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

Labeling X-Y Scatter Plots Figuring out how to get the data points in an X-Y scatter plot labeled can be confusing; Excel certainly doesn’t make it easy. Here’s some ideas on how to add the labels you need. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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

Selecting Fonts for a Chart When formatting a chart, you might want to change the characteristics of the font used in various chart elements. This can be easily done, but the exact steps depend on the version of Excel you are using. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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

Confused by Time?

Helpful Links

Great Info!

RSS Feeds