Microsoft KB Archive/272883

Knowledge Base

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:
  1. Click to select the chart.
  2. On the Chart menu, click Source Data.
  3. 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.

REFERENCES

For more information about data sources for charts, click the Office Assistant, type how data is organized in a chart, click Search, and then click to view the topic.

For more information about how to create a list, click the Office Assistant, type guidelines for creating a list by using the list manager, click Search, and then click a topic to view it.

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar.

Additional query words: off2001kb mac MacXLX XLX XL2001

Keywords: kbpending kbprb KB272883

---

Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.