How to copy colours from another chart w/o changing the chart type in excel 2007?

[HonLee]

How to copy colours from another chart w/o changing the chart type in excel 2007?
<HR style="BACKGROUND-COLOR: #ebebeb; COLOR: #ebebeb" SIZE=1><!-- / icon and title --><!-- message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_start --><!-- END TEMPLATE: ad_showthread_firstpost_start -->in Excel 2002 there was a feature which allows you double click into the chart and goto the colour tab and apply colour scheme from another xls file without loosing any of the other formating like chart types, legends etc... everything else is left unchanged.

Is there a similar function in 2007? cant seem to find it.
please help!
<!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

<!-- controls -->

 

[RoryA]

As far as I know, no you can't do that. The whole make up of the workbook colours has been altered in 2007 with the new Themes. You can import themes from other documents, but not from within the chart formatting dialog.

 

[Steve=True]

I think You can make a style and apply it to the chart without changing the chart elements

 

[HonLee]

thanks! correction from on my part:
the function in excel 2002 is available by clicking on the chart -> tools\Options -> Color tab -> in the Copy colors from drop down select the file you want the definded xls file.