Making legend (or textbox) move as data changes

Hi

I'm trying to make an XY scatter chart which my users will be able to
change, just by changing the data in the data ranges.

The chart contains several curves each having its own legend/text box,
placed at the right end point of the curve.

When the data changes, I need the legend/textbox to move along with
the end point of the curve (colors and different line styles are not
an option).

I have tried to group the curve with the legend/textbox but it doesn't
seem to work.

Any ideas?

mr

Hi,

Maybe these examples will help.

http://peltiertech.com/Excel/Charts/LabelLastPoint.html
http://www.andypope.info/charts/Labellast.htm

Cheers
Andy

mr wrote:

Hi

I'm trying to make an XY scatter chart which my users will be able to
change, just by changing the data in the data ranges.

The chart contains several curves each having its own legend/text box,
placed at the right end point of the curve.

When the data changes, I need the legend/textbox to move along with
the end point of the curve (colors and different line styles are not
an option).

I have tried to group the curve with the legend/textbox but it doesn't
seem to work.

Any ideas?

mr

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info