You (and others) have commented on the difficulty of linking the LegendEntries index to its corresponding Series in VBA.
The blue area series is drawn behind the other series and listed first in the legend, the red columns are drawn in front of the blue area and listed in the middle, and the gold line is plotted in front of the others and listed last. Change series “Area 1” to an area, keep “Column 2” as a column, and change “Line 3” to a line. Then right click on any series and select Change Series Chart Type from the pop up menu. Start with this simple data and insert a clustered column chart (usually the default type). Changing the plot order (by rearranging series in the Select Data Source dialog or by changing the last argument in the Series Formula) will rearrange series within a type, but will not move series out of their plot type order. The order that series are plotted in the chart and listed in the legend follows this order of chart types: Area, Column and/or Bar, Line, and XY Scatter. The rules are straightforward, but they aren’t documented anywhere, so people get confused. The order in which data is plotted in the chart and listed in the legend becomes more complicated when multiple chart types are used in the same chart.
