Batch-export charts

Attempt to detect embedded labels makes use of Excel’s ability to embed text boxes into charts. To embed a text box into a chart, select the chart first, then insert the text box in the usual way. When you subsequently move the chart, you will notice that the text box moves with it. This happens because by selecting the chart before inserting the text box, you embedded the text box in the chart. To have the Toolbox use the text found in embedded text boxes as figure labels for the file name, make sure that you have a consistent way of labeling your charts with embedded text boxes. Thus, you could write Figure 1 or A).


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

Hello. I have just installed XLToolbox; I found it searching for a tool to batch export all charts. This one seems to have what I need; however, its interface looks different than what is shown in your site - it has one single window with only several options, please see attached file.

Can you, please, tell me why don’t I see the same rich interface as shown here on your site?

Thanks in advance!

XLToolbox

Hi @Saputnik,

those screenshots on the website are very old, I just never had time to update them. The new interface looks simpler, but does provide the same feature set. One important difference is that you can define presets with graphic formats (in your example “PNG, 200 dpi, RGB, Transparent canvas”). Just click on “Edit” in the top-right corner to change those settings.

Good luck with your work!

Best

Daniel

Hello, Daniel; thank you for your prompt reply and explanations! Yes, I found my way through this interface easily, it is intuitive; but still that previous interface seems to have more options than this simple interface.

At least, it’s missing one crucial option that I’m interested in: selecting export folder with “Workbook folder” option - I guess that option exports charts to folder where the workbook itself is located, and it would be very useful, rather than selecting folder manually. Is there that option in this new version, and I overlooked it?

Thank you, and keep up good work!

Hi Daniel.

Thanks you create the Toolbox for Excel . it's very convenient.

I have one question  to ask you ,and hope you can have a good solution.

when i use the batch-export charts function , i just only to export one charts.

Because I must filter some filed, example, the name have Tom and Leo

I just get Tom’s chart but can’t get the Leo’s chart .

In the folder, I find the one image as Tom’s chart, not find the Leo’s chart.

So Could you tell me how to fix the problems .

very thanks you answer my question.

water