chart legend changing when I use Select data

[Steve Cawood]

Hi there, I'm hoping this is a simple question. I have a line chart that I
need to update regularly. However, I find that when I change the data, the
labels for the chart (the legend) resets to "series 1, series 2" etc.

I'm currently right-clicking on the chart and choosing "Select data" and
then manually altering the Chart data range.

How do I change the data without changing the legend?

 

[Luke M]

Do you have your series labels defined to a cell, or did you manually type
them? (cell be preferred). Actually, if you are "updating" your chart often,
you might want to look into creating a dynamic chart. Jon Peltier covers a
wide array of different techniques at:
http://peltiertech.com/Excel/Charts/Dynamics.html

This way, you could setup the chart once, and it would automatically update
to display the data you want to show, w/o you having to fiddle with the data
source all the time.