XL97: Chart Data Range Disappears After Changing Series (161929)

CAUSE

This problem occurs when one of the following conditions is true:

• You are building a chart using the Chart Wizard and have made modifications on the Series panel of Chart Wizard - Step 2 of 4.
  
  -or-
• You choose Chart, Source Data, to bring up the Source Data property sheet for a chart that already exists, and make modifications on the Series panel.
  
  -or-
• You click the Series tab of the Format Data Series dialog box, and change the series order after creating the chart.

This behavior occurs because of the overlapping nature of the Data Range and Series panels in the Source Data property sheet. The Data Range field on the Data Range panel is simply a concise range value that can include series names, series values, and category (x) axis labels. Each of these series attributes can be individually modified on the Series panel, despite what range is initially selected when building the chart. Since the Data Range and Series panels are merely different representations of the same plot data, and since the Series panel allows for more detailed modification of the series represented in the chart, changes to either panel can override values on the other panel.

As a result, any modifications made on the Series panel do not automatically roll up to the Data Range panel, but instead cause the Data Range field to appear empty, even though it really isn't.

NOTE: Even if you add a name to a series on the Series panel, then return to the Data Range panel, the Data Range value still appears empty, even though the modification you made might not have affected the values that make up the Data Range.