If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|