I am generating a series of charts programatically via VBA. I can mess around with a chart and edit individual elements like the plot and chart area sizes, fonts, legend, etc. But I can't seem to get it always to come out the way I want. If I look at a chart's settings: plotarea.width, etc., get the values, and place them in my VBA code, the chart doesn't come out like the chart I got the values from. The legend may be in the wrong place or the plot area is too large, etc... I even tried saving as a custom chart type, but it seems like Excel is automatically scaling and moving chart elements. Anyone have any tips on how to generate charts via code and have them come out as you would expect?
Thanks