I have a pivot chart with a bunch of data series, and every time we include/exclude one of the series to see how the chart changes, all the colors change and we have to spend time reidentifying which series is which, using the legend to check the colors Is there a way to "lock" the colors, so that the bars stay the same colors• To change legend text or data series names on the wor ksheet, click the cell that contains the data series name you want to change, type the new name, and then press ENTER 3 • To change legend text or data series names on the chart, click the chart, and then click Source Data on the Chart menu On the Series tab, click the data seriesChange data series names or legend text On the worksheet Click the cell that contains the data series name you want to change Type the new name, and then press ENTER On the chart Click the chart, and then click Source Data on the Chart menu On the Series tab, click the data series name you want to change How To Resolve Leg...