It's not easy, as I have also found. Here's a hint to the procedure. The author's intent is to force a certain aspect ratio on the chart, for the best visibility of trends. Interesting concept, in itself...
Another suggestion farther down, below the ============== bar. Dave http://processtrends.com/pg_data_vis_bank_to_45.htm Excel's chart object includes three areas: Overall chart area (Title, horizontal & vertical offsets, Plot Area) Plot area (Axes marks, labels, area inside axes) Data rectangle (actual data area inside axes) To control the h/w aspect ratio, we must be able to accurately specify the width and height of the data rectangle. How can we directly control the dimensions of the data rectangle? Excel lets Users manually size the chart area and plot area; Excel does not let the User directly control the data rectangle aspect ratio The chart area includes the plot area and titles and offsets, controlling chart area dimensions does not directly control the data rectangle dimensions. The plot area includes the axis tick marks and labels as well as the data rectangle, so the data rectangle aspect ratio is affected by both the plot aspect ratio and axis formatting. Differences in X and Y axis formatting will affect the aspect ratio,. The data rectangle is the actual graph area inside the axis lines. By turning off all X and Y axis major and minor tick formatting, labels and axis titles, we can make the the plot area and data rectangle the same. We can then use dummy axis series to provide X and Y axis labels and text boxes to provide axis titles. To provide data rectangle dimensions based on target h/w aspect ratio, I have developed a multi step procedure to control the data rectangle aspect ratio: Turn off X and Y axis tick marks and labels and axis titles so that the data rectangle and plot area are equal. Create X and Y dummy axis series Run VBA procedure that gets user provided target data rectangle width, Aspect Ratio and offsets, sets data rectangle dimensions, establishes plot area and chart area dimensions based on User input. The VBA procedure lets me specify the data rectangle width and desired h/w aspect ratio. The procedure then sizes the data rectangle - plot area and chart area so that the plot area aspect ratio meet the required value. ======================================================================= You can force the plot area of a chart to be 1:1 ratio'd. Add a dummy series to your chart and change the chart type to Pie. Clear the formatting of the slices. You can also force the x and y scales to be the same by adding another dummy series that plots the Min and Max x and y data value on both the x and y scales.
<<attachment: winmail.dat>>
--------------------------------------------------- https://lists.uni-koeln.de/mailman/listinfo/sundial
