This sounds realistic.

Does this mean that the page formatting will have to be adjusted according to the screen resolution used by the user?

The template spreadsheet contains an army of charts; I write the data to specific areas within the sheet. The graphs now where to look for their data source.

How would I change the size of each chart programmatically.