4 June 2014
Category:
Unsorted
Comments: 6

Bar graphs with InDesign & EasyCatalog

EasyCatalog is terrific for injecting large sets of data quickly and precisely. However, is it possible to create bar graphs thanks to this plugin ? Yes it is, all you need is a bit of ingenuity…

A) Raw data

For our demonstration, we will use some public open data. We will consider the evolution of the services business per country. These data can be found on the World Bank website  : http://donnees.banquemondiale.org/indicateur/BG.GSR.NFSV.GD.ZS/countries

The data host a percentage of the services business between 1960 et 2012. We will focus on the last value, established in 2012 and try to picture it as a bar graph thanks to EasyCatalog.

B) Bar graphs

First of all, we draw a generic bar graph within Adobe Illustrator. Then we will call our bar within EasyCatalog and give it a dynamic width while using a specific field value, i.e. the 2012 percentage.

diagramme_illustrator

C) Custom field “bâton”

Let’s create a custom field within EasyCatalog called  “bâton” : ajout d'un champ personnalisé dans EasyCatalog

paramétrage du champ personnalisé

After validation, we get as expected a “batôn” field within our data. Problem is, any single line is empty. No reference to our bar graph file at all !

champ baton vide

How to get every line to reference our “”baton.ai” file ? One could think about modifying its source data…There is much better to do. We are going to use the cleansing options. As all our lines are empty, we are replacing this emptiness with “baton.ai” with this very simple instruction : “=baton.ai;”

cleansing baton

Doing so, every cell is now filled with “baton.ai”

cellules remplies avec baton.ai

Now we have to tell EasyCatalog to consider this data as an image field. So the “baton.ai” is not just a string but a link towards a file on our computer.

choix_dossier

By setting the location of our file, EasyCatalog converts the field type. It’s now an “image” field. Besides, you can now preview the picture by hovering the column cells.

Previsualisation image

An essential input is still missing. At this state, the file would be placed as it is with 100% scale. We need to adjust our bar graph size to represent the data. 

We will tell EasyCatalog to scale our bar graph based on the 2012 field value.

reglage echelle

D) Use

All we have left to do is to prepare our layout. Let’s take a very simple table for our demo :

tableau simple

Let’s take a bunch of data and paginate it thanks to EasyCatalog.

tableau produit

Et voilà ! Nice bar graphs in just a few clicks. Other layouts can be achieved, still easy‑peasy !

diagrammes en batons

E) Conclusion

Create bar graphs with EasyCatalog is really possible. Even better, it’s easy ! This plugin is so smooth that everything seems feasible.

Sky is the limit. Feel free to get in touch with us if you have other projects, we will analyze their feasibility together !

6 responses on “Bar graphs with InDesign & EasyCatalog

  1. Laila says:

    I’d love to know the exact steps of what I click to reach those boxes. Unfortunately I don’t speak any French, so I don’t know where the steps should lead. Any help? Maybe with shortcuts?

  2. Loïc Aigon says:

    Hi Laila,

    What is it exactly you didn’t understand ?

    Best regards,

    Loic

  3. Emma Glaisher says:

    Cunning use of EasyCatalog! It never ceases to surprise me. I think if you’re reasonably familiar with EasyCat you should be able to follow this without needing to understand French. There is one paragraph untranslated: “En indiquant l’emplacement de notre fichier…” However it is purely descriptive and the context makes the meaning obvious.

    • Loïc Aigon says:

      Hi Emma,

      Thanks for your comment and appreciation. I also share this feeling of EasyCatalog Awesomeness 🙂
      I translated the remaining french part. Thanks for pointing it out.

      Loic

  4. Raquel says:

    Hi,
    Thank you for posting this tip. I have tried it and cant seem to get the bars to scale with my referred field. Should the field with the number contain a percentage or have any specific format?

    Thank you!.

Leave a Reply

Your email address will not be published. Required fields are marked *