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? |
chart legend changing when I use Select data
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? |
All times are GMT +1. The time now is 10:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com