Bizarre problem exporting graph as jpg... always gives wrong dimensions!

Hello everyone,

For one of my publications, I need to export a graph that is exactly 34.2 cm wide x 22.5 cm tall. It is a graph in a spreadsheet tab (not a chartsheet!) in a workbook with 50+ similar graphs to be used for the same publication. No matter what I do, when I export the graph as a jpg, it always has the wrong dimensions. It's not an option to use other software or recreate the workbook. We must use this file.

I've tried adjusting the dimensions of the chart area manually in Excel:
Capture1.GIF



I've tried adjusting the dimensions with VBA:

Please Login or Register  to view this content.

I've even tried exporting this with add-on software, such as KUTOOLS and XL TOOLBOX NG. Doesn't work.



No matter what I do, the jpg always has the wrong dimensions:
Capture2.GIF
1036 pixels = 27.4 cm
683 pixels = 18.1 cm



I've scoured the internet for help, but nothing is working. A simplified version of this spreadsheet can be downloaded from my Google Drive:

https://drive.google.com/file/d/1d2b...ew?usp=sharing

Does anyone have any ideas on how I can fix this? Thanks so much for your help.




P.S.

Here is the code I'm using to export the images as .jpg files:

Please Login or Register  to view this content.

Hi xlnitwit...

That is indeed a solution that crossed my mind. But it's likely that other charts are going to have this same problem (we have hundreds we need to export as jpgs), and it would be extremely inefficient to figure out custom dimensions for each graph. This is just one example.

Do you have any ideas on how I could go about this more efficiently?

These charts are being sent to our publisher to be put in our upcoming end-of-year publication.

The 34.2 x 22.5 dimension is the size specified by our publisher.

The images can't be forced to artificially fit the dimensions because they will become pixelated and not be of high enough quality for our publication.

That's why I really need to find a way to export these in the right dimensions.

Not an expert in this area, some I'm unsure. But I guess, if they didn't specify this, that they assume that the standard settings are okay?

Let me give some more information:

For MOST charts in our workbook, the jpg output matches perfectly the dimensions that we specify in the format - size tab. This is good enough for the publisher.

It's only in a minority of graphs that we get output dimensions in the jpg that differ from what we enter in the format - size tab.