Prev: How to change series plotting order without changing legend order?
Next: printing problems
From: Steve Cawood on 1 Dec 2009 10:50
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?
From: Luke M on 1 Dec 2009 12:46
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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Steve Cawood" wrote:

> 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?
 | 
Pages: 1
Prev: How to change series plotting order without changing legend order?
Next: printing problems