chart formatting is lost when copying to new workbook 2

[crawfme]

When I copy a worksheet with a chart to a new workbook the formatting of the x-axis is lost. In the source workbook the format is a date formatted as Oct-07, but when I create a copy the date becomes 39356 which is the numeric value for Oct. 1, 2007. Is there any way to retain the formatting? I'm using a macro to create the copy.

I'm using Microsoft Office Excel 2003.

Thanks.

 

[SkipVought]

Hi,

"I'm using a macro to create the copy."

Extend your macro to format the value axis.

I can't say why its happening.


Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[xlbo]

Probably has the chart property of axis format linked to source set up.

If you go into the number tab on the format properties of the X axis, you should see a tick box which says "Linked to source"

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[crawfme]

Thanks, Geoff. I clicked off the "linked to source" and that fixed it.

 

[SkipVought]

crawfme,

After that nifty TIP from Geoff, you might want to...
[blue]
Thank xlbo
for this valuable post![/blue]

Thanking someone for their valuable post by clicking the hyperlink in the lower left-and corner of
their post, not only let's them know of your gratitude, but also identifies that thread as having such
valuable information that some other member might find beneficial.

Not only that, but it shows your fellow members that you are a gracious individual.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}