What is the way of changing chart defaults (other than making new templates), especially the chart size, 'legend' font size, 'axis items' and 'axis title' font size, 'chart title' font size?
The change can apply to all the chart types in excel.
1. The legend size is set to 10 by...
I have set up a reporting dashboard that updates automatically every time new data is inserted into another worksheet I use as a database.
Initially the dashboard was not dynamic and looked great but every time I updated the data I had to update each graph. Now it is all dynamic and...
I am looking at customizing the chart templates for excel 2003. I have few questions.
1) In excel if I add an chart, it comes up with some default settings like borders, grey background etc.
How do I modify the template of each chart for multiple things like border, color etc, so that for the...