Tips.Net > ExcelTips Home > 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.
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
You can put times into a worksheet, but then what? Need to do calculations with times? How about working with elapsed time? Don't be confused; learn how easy it can be. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site