Resizing diagrams without getting a "compressed" or "stretched" result

**Kribulin** · 06-09-2008, 10:37 AM

I have several charts which I want to make the same size, without some getting "compressed" and others "stretched"?

My goal is in other words to get uniform diagrams.

**Leith Ross** · 06-09-2008, 10:53 AM

Hello Kribulin,

What type of diagrams are you referring to? Are they Excel AutoShapes, jpeg files, WMF files or something else?

Sincerely,
Leith Ross

**Kribulin** · 06-09-2008, 11:01 AM

Excel scatter charts.

**Andy Pope** · 06-09-2008, 11:10 AM

If they are not all currently the same size then how do think you can resize without either stretching or compressing?
You have to change the dimensions of some of the charts.

Which one of the charts should be used as the default size?
Or are you using some other method of determining the default size?

**Kribulin** · 06-09-2008, 11:21 AM

I haven't used any method to determine the default size, i.e. they are by the default the size "suggested" by Excel.

I guess they have to remain different sizes then, or I will have to accept some stretching/compression..

If so, is it at least possible to resize the charts to their original size again (without reseting other parameters)?

**Andy Pope** · 06-09-2008, 11:34 AM

I'm very confused.

You say set them back to their original size. This would suggest that some operation or person changed them. Is that so?

Maybe an example workbook would help us understand your problem.

**Kribulin** · 06-09-2008, 11:54 AM

Yes, I've been experimenting with the sizing, which has resulted in that the length-vs.-height ratio is now unproportional.

Okey, thank you for your help. As example, I've attached the links to two files, both containing one chart. I would like these two charts to be uniform.

http://www.uploading.com/files/06KOCVAC/temp1.xls.html
http://www.uploading.com/files/3QI605TB/temp2.xls.html

**Andy Pope** · 06-09-2008, 12:00 PM

Please Login or Register  to view this content.

**Kribulin** · 06-10-2008, 03:02 AM

Wow, what's that, how do I use it and what does it do?

**Andy Pope** · 06-10-2008, 03:37 AM

It code to size 1 chart the same as the other.

If you don't want code then select a chart whilst holding the shift key.
Right click and go to the Size tab. Set the Width and Height values as required.
Repeat for other charts.

**Kribulin** · 06-10-2008, 10:05 AM

I decided to make new charts and then copy-paste the format from one to the others. Thank you for your help!

Resizing diagrams without getting a "compressed" or "stretched" result

LinkBack

Thread Tools

Rate This Thread

Display

Resizing diagrams without getting a "compressed" or "stretched" result

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions