Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Sparklines are not filled in the new cells that correspond to extended ranges in Excel


View products that this article applies to.

Symptoms

Consider the following scenario:
  • You use a dynamic range as the data source for sparklines in a Microsoft Excel worksheet. For example, you use an�OFFSET formula when you specify the range.
  • You use a dynamic reference for the location range that you want sparklines to be displayed in.
  • You extend the data source range.
In this scenario, the existing sparklines are updated based on the data in the extended data range. However, sparklines are not filled in the new cells that correspond to the extended ranges.

↑ Back to the top


Cause

This problem occurs because the dynamic range is converted to a fixed absolute reference.

↑ Back to the top


Workaround

To work around this problem, follow these steps:
  1. In the worksheet, click the last cell that contains sparklines.
  2. Drag the outside selection of the cell to extend the sparklines to new cells. Then, sparklines are filled in the new cells.

↑ Back to the top


Status

This behavior is by design.

↑ Back to the top


References

For more information about How to use defined names to automatically update a chart range in Excel , click the following article number to view the article in the Microsoft Knowledge Base:
183446 How to use defined names to automatically update a chart range in Excel

↑ Back to the top


Keywords: KB981236, kbprb, kbsurveynew, kbtshoot, kbexpertiseinter

↑ Back to the top

Article Info
Article ID : 981236
Revision : 5
Created on : 10/31/2012
Published on : 10/31/2012
Exists online : False
Views : 387