square chart with excaclty defined dimensions
 

Be aware that few people will open your attachment.

The rule for the ng is NEVER attach anything.

Just ask if someone will look at your workbook and if
they reply YES, you can arrange to send it to them by email.

--
steveB

Remove "AYN" from email to respond
"Janwillem van Dijk" wrote in message
. nl...
After a lot of trial and error I came up with the solution presented in
the attachment for reformatting a chart such that the inside dimensions
are exactly the ones you defined, e.g. a square of 70 x 70 mm.

For the cases I needed (only XY-scatter) it worked fine but do not be
surprised if miraculous things happen when you try it on your own
charts; a lot of surprising phenomena, or hidden intelligence if you
like, in the chart world.

Thank you for the suggestions in this news group.
Janwillem

P.S. I am from the ALGOL-60 days and have ever since made an effort of
not using BASIC. I would therefore not be surprised when some of you can
improve considerably on the coding.

The xls file is compressed with the Open Source 7-Zip
http://www.7-zip.org/