To work around this behavior, create a macro that reduces the font size of the Excel chart legend text before your VBA macro changes the chart legend and then restore the font size of the chart ...