Topic: Creating Charts

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

Automatically Creating Charts for Individual Rows in a Data Table Got a huge amount of data in a data table, but you only want to select a single record from the table to create a chart? This tip presents three ways you can access just the information you want and create a dynamic chart based on that information. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Controlling the Plotting of Empty Cells Excel provides a great deal of control in how it constructs a chart based on worksheet data. This tip explains how you can configure Excel to treat empty cells in different ways. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Easily Changing Chart Data Ranges Many times you use the same chart format to graph a subset of information from a full data table. This tip presents a detailed tutorial on how to make your charts more dynamic and easier to use. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Graphically Charting Geographic Data Excel can do all sorts of charts, but its ability to create geographic charts depends on the version of Excel you are using. This tip discusses the options available and how you can get the type of geographic chart you need. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Make that Chart Quickly! Want to create a chart in the quickest way possible? This tip introduces a very simple shortcut key that allows you to create a chart with a single keypress. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Moving Groups of Data Labels at One Time Data labels on charts can be moved individually to any position desired. If there are quite a few data labels on a chart, this means quite a bit of work if you want to move them all. This tip reveals a free add-in you can use to make working with data labels easier. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Multiple Data Points in a Chart Column Excel provides lots of ways you can create charts. This tip provides some pointers on how you can combine stacked column charts and clustered column charts in ways you may not have been aware of. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Numeric Value and Percentage Value in a Graph Column Do you want to include two data labels with your chart? Exactly how you can achieve this feat isn’t intuitive in Excel, but once you learn the trick you’ll be able to display the labels just the way you want. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Specifying Chart Sizes When Excel creates a chart in a worksheet, it sets the initial size of the cart based on a variety of factors. If you add multiple charts to a worksheet, you may want those charts to all be the same size. There are a couple ways to accomplish this task, each explored in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Specifying the Size of Chart Objects Create a new chart object in an existing worksheet, and Excel automatically makes the object 25% of whatever the screen size is. If you want a different size (without manually resizing), you are out of luck unless you use a macro to create the chart object. This tip explains how you can do this. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Tips, Tricks, and Answers

Macros 'Power Up' Excel!

Helpful Links

Great Info!

RSS Feeds