I have a chart that I wish to export as a picture to PowerPoint. This chart
contains data labels for the last value in each series, which have been
formatted to the colour of that series.

However, when I copy this chart as a picture (using VBA code, although the
same thing happens when I do it manually) these data labels lose their
formatting and appear in black.

Is this by design or am I doing something wrong?