Help! Excel Charts losing formats

[Rollin_Again]

I am using Excel 2000 SP-3 on a Windows 2000 machine and have bee
having some strange problems. I have 4 charts that are in a singl
workbook along with the source data for them. After the workbook ha
been updated and the charts are correct, I am copying the charts to
brand new workbook by right clicking the worksheet tab and selectin
copy option. I am only copying the chart to the new workbook, not th
data. Two of the charts copy fine but the other two charts ar
changing from having a gray background to an orange background. I a
currently manually having to go to these charts and set the backgroun
to the right one.

In addition to this, when the charts are inserted into an Outloo
message and emailed, they are losing other formats that are containe
in the original charts. The most obvious difference is that the Y axi
of the chart changes from a Date format to what appears to be a genera
format. Instead of seeing a date such as 2/11/04, all the recipient
are seeing a number such as 38027. Also, the Y axis date labels ar
losing their alignment format. Anyone else had these problems or kno
a solution?

Thx
Rolli

 

[Debra Dalgleish]

Jon Peltier has code for copying and pasting Excel charts as pictures.
You could adapt it to your workbook:

http://www.peltiertech.com/Excel/XL_PPT.html

 

[AlfD]

Hi!

<shift> + <edit> brings up the option of saving a chart as a picture.

Al