Copying Chart As Picture To PowerPoint

[IanC]

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?

 

[Jon Peltier]

This happened with a client's computer, but not on my computer, nor on other
computers at the client's facility. I don't recall the specifics, but I
think we decided it must have been related to an out-of-date printer driver.

- Jon

 

[IanC]

Thank you.

I updated the printer driver and there was still no luck - when exported to
PP, the lines would come out in colour, but the text boxes were b&w. I then
tried changing the printer to a colour one and the text boxes came out in
glorious colour too.

I have no idea why this should be, but am just grateful.


IanC