Microsoft KB Archive/272883

= Chart's source data reference is not updated when you insert a list object around chart data in Excel for Mac =

Article ID: 272883

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2004 for Mac
 * Microsoft Excel X for Mac
 * Microsoft Excel 2001 for Mac

-



This article was previously published under Q272883



SYMPTOMS
When you insert a list into a workbook, the data in the selected cells is shifted down one row to accommodate the list's column headings. If data located in the list is being used as source data for a chart, the chart may display the data incorrectly.



CAUSE
This behavior can occur because the reference for the chart's data series is not adjusted after the source data is shifted down one row to accommodate the insertion of the list's column headings.



WORKAROUND
To work around this behavior, use one of the following methods:
 * Create the list first, type the data in the list, and then create the chart, using the data inside the list.
 * Edit the data series so that it refers to the correct cell references; to do so, follow these steps:
 * Click to select the chart.
 * On the Chart menu, click Source Data.
 * In the Source Data dialog box, under Data range, type the correct cell reference that contains the data for the chart, and then click OK.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
If the source data is supposed to be outside the list, avoid placing the list to the left or right of the chart's source data, and leave at least one row between the list and any source data below it.

