I am using Excel 2003 and have data in a XY Scatter chart. I have an
existing file where I would like to display the Series name as the data
label. When I open the file only a small number of data labels are
displayed. For instance, 2 out of 8 entries for one chart and 19 out of 36
for another chart are displayed. I must go into Chart Options and uncheck
then recheck the Series Name box on Data Labels tab in order to have all of
the data labels appear on the chart. Even if I save the file after
displaying all of the data labels the next time I open the file I'm back to
having only a select few data labels displayed. Any suggestions as to what
is causing this or a way to prevent it in the future?

Hi,

I have the same error. I have to chekc/unckeck to make the label appear and
then, If I save and reopen the excel file, they're gone!



"md3684" wrote:

I am using Excel 2003 and have data in a XY Scatter chart. I have an
existing file where I would like to display the Series name as the data
label. When I open the file only a small number of data labels are
displayed. For instance, 2 out of 8 entries for one chart and 19 out of 36
for another chart are displayed. I must go into Chart Options and uncheck
then recheck the Series Name box on Data Labels tab in order to have all of
the data labels appear on the chart. Even if I save the file after
displaying all of the data labels the next time I open the file I'm back to
having only a select few data labels displayed. Any suggestions as to what
is causing this or a way to prevent it in the future?

I had the problem with series created from C# with code like that one :


Excel.Series S = C.NewSeries();
S.Name = "=" + FirstRR.LegendRange.get_Address(true, true,
Excel.XlReferenceStyle.xlR1C1, true, Type.Missing);
S.XValues = FirstRR.RiskRange;
S.Values = FirstRR.ReturnRange;
S.MarkerBackgroundColorIndex = FirstRR.Color;

As I have only One point in each Series, I changed to

Excel.Series S = C.NewSeries();
S.Name = "=" + FirstRR.LegendRange.get_Address(true, true,
Excel.XlReferenceStyle.xlR1C1, true, Type.Missing);
S.XValues = FirstRR.RiskRange;
S.Values = FirstRR.ReturnRange;
Excel.Point P = (Excel.Point)S.Points(1);
P.MarkerBackgroundColorIndex = FirstRR.Color;

And it works well...

Another Excel Mystery!




"SD" wrote:

Hi,

I have the same error. I have to chekc/unckeck to make the label appear and
then, If I save and reopen the excel file, they're gone!



"md3684" wrote:

I am using Excel 2003 and have data in a XY Scatter chart. I have an
existing file where I would like to display the Series name as the data
label. When I open the file only a small number of data labels are
displayed. For instance, 2 out of 8 entries for one chart and 19 out of 36
for another chart are displayed. I must go into Chart Options and uncheck
then recheck the Series Name box on Data Labels tab in order to have all of
the data labels appear on the chart. Even if I save the file after
displaying all of the data labels the next time I open the file I'm back to
having only a select few data labels displayed. Any suggestions as to what
is causing this or a way to prevent it in the future?