Resizing a chart and table (not so simple)

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.