I have found some very useful posts on this forum on creating dynamic graphs and charts in excel. I would like to find some way in excel of preserving the standard formats of charts every time they change dynamically as a result of new data. The standard formats would be size of the chart area, scale of axis, formatting of labels, position of the legend on the chart etc. Things like chart titles would change automatically as they would be linked by a formula to a cell in the worksheet which changes dynamically as the chart updates, but some help on the standard position of the chart title in the chart area as the chart changes would help.
Many thanks for help,