I have a fairly large workbook. About 50% of the worksheets are charts that are updated on a daily basis. A VBA macro goes to each chart worksheet and does a "save as webpage-chart only". The chart itself is saved to a gif and a new webpage is made that displays the gif. That part works great. The problem is that I want to make the chart appear bigger for easier reading. I could edit each and every webpage every day to indicate the height and width of each gif to be displayed but I would really rather avoid that task.
So the question is: Is there a way to specifiy during the save as webpage what the height and width of the chart should be?
So the question is: Is there a way to specifiy during the save as webpage what the height and width of the chart should be?
