Making legend (or textbox) move as data changes

M

mr

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide line and legend when data not present 0
Legend changes after closing file 1
chart legend changing when I use Select data 1
Changing/Manipulating Legend range for a Pivot Chart in XL2010 vsXL2003 and below. 0
Format a data point without changing the legend 2
Legends - Everyone stuck? 3
change the text in the legend of a chart w/o changing pivot text 2
Data disappears when I edit the chart. 1

Top