I would like to change the default chart colours used in Excel (XP). I know the simplest way to do this would be to save a file called book.xlt in the xlstat folder but my employer's security policy prevents me from doing this.
I wondered instead if it would be possible to put some code in personal.xls (which I can edit) that would change the defaults, but I don't know how to do this. Ideally I also want to make some other changes to the chart defaults such as background colour and axis font.
Many thanks for any suggestions.
PS also tried changing the default chart type but it just resets to the original.