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!
Bookmarks