Difficult Chart Resizing Problem

**Jet0L19** · 05-21-2012, 02:36 PM

Ok, bare with me here and refer to the attached image for reference.

I need to resize a table along with a chart(bar graph) so that it fits to a specific "measurement". Basically, everything looks exactly the way I want it to now, but my problem is that I need to grab each chart(with table) individually and put them into a word document, WITHOUT resizing. I don't want the heights of my vertical axis to get skewed when I paste the image into the word document.

My word document has 1 inch side margins, which leaves me a total size of 6.5" as a max distance of the largest table(in the picture, the table corresponding to the blue has the widest distance. As you see in the picture, the blue chart alone is a width of 8.19", meaning the table included snapshot must be at least 8.5", 2" too large. Therefore to fit it, the image has to be shrunk down.

My only solution: essentially, I could shrink the charts both proportionally so that the largest is 6 inches, and therefore the blue chart's table would be about 6.5" and no greater, therefore when I pasted these two separate pictures in, the vertical axes would be the same exact height. That is my goal. Unfortunately, In order for this to work, I'll also need to decrease the font size of the tables, as well as the width of the columns so that it lines all up pretty like it does now. I will then need to manually stretch the actual plot size so the bars are perfectly over the corresponding amounts. That is a LOT of work for such a dumb problem to have. Especially, because I have to do this for about 30 different workbooks.

There HAS to be an easier solution than mine to this problem. Please ask if you have any questions or I was unclear.

P.S. The way the image is grabbed from excel is essentially like a print screen, except it captures the exact dimensions of the chart in excel. i.e. you can't just zoom out and take a print screen so everything is smaller.

**Søren Larsen** · 05-21-2012, 02:50 PM

What I usually do in cases where my Excel chart don't fit a Word template is to copy the chart and paste it into Microsoft Picture Manager and then copy/paste from there to Word, and resize the picture in Word to fit my template. Perhaps you can do the same in your situation.

**Jet0L19** · 05-21-2012, 07:22 PM

I'd like to just be able to do that, it's a good solution, but unfortunately, I'm building these for a different group of people that are very specific about how they want to insert these into their word templates lol. Thank you for the tip though.

**FDibbins** · 05-21-2012, 08:43 PM

i have no clue on how to do it, but im sure some1 should be able to come up with some VBA code that will do all that for you. if you dont get a reply back soon, suggest bumping your thread?