Thread: chart legend changing when I use Select data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Steve Cawood Steve Cawood is offline
external usenet poster
  
Posts: 1
Default chart legend changing when I use Select data
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?
Reply With QuoteReply With Quote