Charts

Tips, Tricks, and Answers

The following articles are available for the 'Charts' topic. 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.

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.

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.

Excel Charts in PowerPoint
A common place to use Excel charts is in your PowerPoint presentations. How you paste those charts into the presentation can have a profound effect on the size and security of the PowerPoint file.

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.

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.

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.

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.

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.

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.

More Information

The following are additional topics related to the subject of 'Charts'. A bracketed number after the topic indicates how many articles are related to that subject.