Using Excel 2010. I create a bar chart using data in a worksheet. If I add a legend, the legend displays the "Series Name" from the "Legend Entries (Series). By default, all bars have the same fill color. If I change the fill color of one of the bars, the legend changes to display the X axis labels, the "Horizontal (Category) Axis Labels". If I do not display a legend I can change the colors of the bars with no additional side effects. Does anyone know how to turn this automatic change off? I want to display the Series Name, not the X axis labels (they are already clearly displayed on the bottom of the chart.
Thanks for any assistance with this.
Bookmarks