| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Why do I lose legend labels when updating chart data?
Each week I update my charts by adding a column to the source data and then
updating, or extending, the chart to include the new week. One of my charts has a problem in that when I do the update, the legend labels revert to "Series 1, Series 2," etc. Is there a setting I can use to stop that from happening? I have other charts that don't exhibit this behavior. Thank you. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Why do I lose legend labels when updating chart data?
Hi,
The default Series 1, Series 2 etc are used when no information is supplied for the series name. Are you including a row or column that contains series name when you adjust the source data? Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "HRGeneralist" wrote in message ... Each week I update my charts by adding a column to the source data and then updating, or extending, the chart to include the new week. One of my charts has a problem in that when I do the update, the legend labels revert to "Series 1, Series 2," etc. Is there a setting I can use to stop that from happening? I have other charts that don't exhibit this behavior. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I place the legend next to the data point on a chart? | Charts and Charting in Excel | |||
| Dynamic legend labels | Charts and Charting in Excel | |||
| Legend Labels Entry | Excel Discussion (Misc queries) | |||
| Hide series names for unused data from chart legend | Charts and Charting in Excel | |||
| combine "category labels" & "values" in legend | Excel Discussion (Misc queries) | |||
Linear Mode
