High-resolution graphs for publication


An alternative to the high-resolution graphic export is the screenshot-quality export:

This is better suited for graphs that you want to use in digital media, e.g. in e-mails or presentations. One important difference between screenshot-quality export and high-resolution export is that the former produces ‘anti-aliased’ images where ragged lines are made smooth by interpolating with shades of gray (and other hues). The high-resolution export does not use anti-aliasing, so that text may appear ragged when zoomed in on screen. However, for printing on paper, this mode is preferable.

This is a companion discussion topic for the original entry at https://www.xltoolbox.net/scientificpublishing.html


I used to be able to export high quality graphics to PNG/TIFF files with this XL toolbox. In fact, this was one of the biggest uses for Daniel’s XL Toolbox that I had.

Lately in the past few versions I’ve noticed that this ability is lost. The “export with settings” produces large graphics, but they look horrible. I understand that this is because the toolbox lost the functionality to anti-alias them, so they now look jagged. Only the “screenshot” mode retains anti-aliasing, but it produces very small images.

I am confused why the new version removes functionality that already existed in previous versions. Not everyone wants to print the high quality graphics. These days there are very high resolution displays as well, and I’d like to obtain high resolution graphics that are properly anti-aliased so they don’t look jagged.

I was able to do this in previous versions of Daniel’s XL Toolbox, but for some reason this working feature was removed in newer versions.

Is it possible to get this feature back?


Anne, thanks for your input.

The XL Toolbox uses functions built into Windows in conjunction with something called FreeImage to produce the high-resolution graphics. This has not changed between the ‘legacy’ versions (up to 6.60) and the ‘Next Generation’ versions (7.0 and up). What did change was the programming language of the XL Toolbox: It used to be Visual Basic for Applications, and now it is the state-of-the-art .NET technology (C#).

So, in theory, because the underlying technology is the same, the graphics should look the same whether they have been produced with the legacy Toolbox or the Next Generation.

Having said that, I have received a similar comment from a user a little while ago. Unfortunately, for me the graphics look fine, which makes me wonder whether there are issues pertinent to the specific version Windows that Excel and the Toolbox are installed on.

My primary use case is to produce print-quality graphics, where smoothing is not desired. In fact, I am a little worried because currently all of the graphics exported with the XL Toolbox are smoothed (zoom in to see). After playing with the code a little tonight, I think I have found a way to obtain graphics that are not smoothed at all, and this technique might lead to some sort of user preference setting for the XL Toolbox.

If you want to send me an example graphic that you are not happy with, you can send me a private message by clicking on my user name in the forum. I could then have a look at it.


I have been happy with the toolbox export feature.
However I now cannot use it.
I get the following error:
‘System.__ComObject’ does not contain a definition for 'Copy’
I am using Windows 10
Can you help?


Please send me a copy of the file that is causing this error (if at all possible with regard to privacy considerations). You can click on my user name, then Message. I’ll investigate.


I would like to export Chart2(8) as TIFF 300 dpi
Your help is greatly appreciated.
I attached the file to my reply to your email.
Thank you


I would like to export Chart2(8) as TIFF 300 dpi
Your help is greatly appreciated.
Thank you


John, unfortunately it works perfectly well here…

You wrote you are using Windows 10. What about your Office version? Also, is it 64-bit or 32-bit?

You can find out by going to File -> Account -> About Excel:


For some reason it works today.
Thank you for your help, but I am OK.
By the way, I want to say its a great tool box.