Peltier Technical Services, Inc.
- Custom Excel Solutions

PTS Blog: Charts and Things

Jon's Excel and Charting Pages
- Jon's Charts - Tutorials - Excel
- Site Index and Search - RSS

The Excel Chart and its Data Range

You may notice that when a chart is selected, its source data range in the worksheet is highlighted (see the previous few screen shots and the larger view below). The Y values in the chart are within the blue outlined range. The Category (X axis) values are outlined in purple, and the Series names (legend entries) are outlined in green. Each outline has a handle -- a small square of the same color -- at its lower right corner. The source data range of the chart can be enlarged or contracted by dragging these handles. The source data can be moved by dragging one of the colored outlines.

In the same way that a chart's source data is highlighted when the chart is selected, an individual series' data ranges are highlighted when that series itself is highlighted (see below). These data ranges can be moved or resized by dragging these outlines or handles, in the same way that the chart's source data can be adjusted.

Peltier Technical Services, Inc.
We can customize or automate any example from this site, or build a new one for you. To discuss your project or obtain a quote, please contact me at jonxlmvp@peltiertech.com

PTS Blog: Charts and Things

Jon's Excel and Charting Pages
- Jon's Charts - Tutorials - Excel - Site Index and Search - RSS

Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

My MVP Profile