Excel DataLabel - now you see it - now you don't

[Clive Horton]

I have written an Excel VB macro that plots Patient
Treatment & Disease Status vs. Time - Some DataLabels,
showing continuous treatment, are 'fetched' from an
earlier start date (in the plot-table) to the plot area
using the VB command "Selection.Left = (value)". Such
labels are visible in Excel 97 but not in Excel 2002.
Is this a bug in Excel 2002, or is there a way round this
problem?

 

[Jon Peltier]

Clive -

Here's what I would do. I would attach these data labels to dummy
points, which stay in place either because I plot the dummy series on
invisible secondary axes with fixed endpoints, or because the macro
that scrolls left and right changes the dummy points' X and Y values
accordingly. I think I would put the dummy points along the vertical
axis, and use the Left position alignment setting of the data labels.

You're not crazy. I have noticed differences in how Excel 2000
displays data labels beyond the plotting rectangle, compared to how
Excel 97 displayed them.

- Jon