Copying Chart As Picture To PowerPoint

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?

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"IanC" wrote in message
...
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?

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

"Jon Peltier" wrote:

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"IanC" wrote in message
...
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?