Share this Page URL

Chapter 27. Creating and Editing Charts > Troubleshooting - Pg. 726

Creating and Editing Charts 726 TIP FROM If you copy a worksheet range to the Clipboard, you can right-click the plot area or chart area and select Edit, Paste to add the series to an existing chart. When you select a data series on an embedded chart, the Range Finder displays a colored line around the corresponding range within the data source; the Range Finder also adds a border around the value axis labels and category labels, using different colors for each. Drag the selection by using the rectangular handle in the lower-right corner of each selection to extend or move the data range for each series. On a chart where the data source consists of a single contiguous range, selecting the chart area causes the Range Finder to highlight all the data series in one color, the value axis labels in another color, and category names in still another color. TIP FROM Excel uses the Range Finder only when the chart and its corresponding data range are on the same worksheet. Take advantage of this feature to debug problems in charts. If your chart is on a separate sheet, right-click the chart area and select Location; then click the As Object In option and select the worksheet that contains the charted data. Resize and re- position the chart object so it's near the corresponding range within the data source and use the color-coding to identify which data series is causing the problem. After you've fixed the chart, use the Location shortcut menu to move it back to its own chart sheet. When using the Range Finder with charts, you should be aware of the following limitations: · The Range Finder works only with a chart object that is embedded on the same worksheet as the data. It does not work with charts on chart sheets. · You can drag to expand the data range or a given series to include new data in either direction; however, this technique works only for contiguous series. If any series consists of a noncontig- uous range, you must use the wizard or the Data Source dialog box to select the data. · When you click an individual data point, the Range Finder highlights the series that contains that point. Advanced Chart Options Excel's advanced chart options let you add details that help you spot trends more easily. For ex- ample, in a line chart that plots daily closing stock prices over time, you can add a trendline and a moving average that smooth out some of the peaks and valleys in the data. You can do the same with a column chart to show a smooth trend over time. Select the series, right-click, and select Add Trendline. For charts that project data, you can also add error bars that define the upper- and lower- error limits of your projections by using standard statistical measures. You'll find these options on the Error Bars tab of the Format Data Series dialog box. NOTE For more information on how you can display detailed analyses in Excel charts, see Special Edition Using Microsoft Excel 2003, by Patrick Blattner (published by Que, ISBN: 0-7897-2953-9). Troubleshooting Formatting Combination Charts I created a Pie-of-Pie or Pie-of-Bar chart, but I'm having trouble formatting it.