Creating Graphs, Charts in InDesign

[BruinSID]

Is there an easy way to create detailed pie charts and graphs in InDesign, for use in high Res print publications?

[Obi-wan Kenobi]

Jane,

Dans ce cas, ne copie pas dedans !!! … mais fais un trou dans le mur ! 

[nicolee29025779]

Found this. Haven't tried yet but it looks promising.

Creating Graphs in Adobe InDesign - YouTube

[jane-e]

nicolee29025779  wrote

HI Nicolee,

Two people mentioned the Chartwell font on October 22, 2014 and one of them linked to the same video that you did. There have been several other mentions of Chartwell in this thread — you might want to scroll through and read the entire thread.

[Colin Flashman]

There is also a way to create bar graphs using a free script that I wrote for InDesignsecrets - it employs GREP to look at a number between 0-1999 and represent it as a bar graph. Have a look: https://indesignsecrets.com/a-script-for-making-bar-graphs-with-grep.php

Using this script, it is then possible to create modern looking infographics using a technique I demonstrated on my youtube channel: Episode 12: Data Merge Infographics with Chartwell - YouTube

[boots_n_patches]

just  for  additional  option …

the  past  couple  flavors  of  mac-os  include  "numbers"  app … which  is  part  of  "iworks"  productivity  suite.  numbers  is  their  spreadsheet  variant … create  many  different  types  of  graphs/charts … can  import/export/save … etc.  as  long  as  the  user  works  inside  numbers … the  data  can  continually  be  updated.  when  ready,  can  paste  into  illustrator  or  indesign.  if  using  copy/paste/pdf … limited  elements  will  retain  vector  optimization … most  elements  pixelate/raster.

however … sure  beats  creating  new  graphs  every  time  the  data  changes.  again … this  is  only  for  recent  mac-os (v10.12)  and  later.

[Bevi Chagnon - PubCom.com]

It's 2023.

Time for an update on this discussion.

We've tested several programs listed in this thread to create data charts for use in professional publishing apps like Adobe InDesign.  With our projects, client data visualations include simple pie/ring charts, line/bar/column charts, stacked columns, combo bar/line charts, scatter charts, and candlestick charts (like stock market charts).

Our projects contain 10-30 chart graphics, all different kinds, and they must maintain a unified, professional design and appearance. Fonts and colors can't change between the charts.

As of last month, no tools can do this type of data graphing except MS Excel and Tableau. In fact, these programs make it easy for anyone to generate the chart right from the original data source. Update the data and the chart updates as well.

Downsides:

• Appearance isn't exactly professional design, if you know what I mean.
• Can't adequately control fonts, size, leading, and placement. Things change from chart to chart.
• Can't adequately control color palettes and schemes, especially for print/press. In MS, learn how to set color themes that will work for your print projects; this will help control the colors for the charts.
• Difficult to get a press-quality hi-rez graphic from these programs. We found that a 600 dpi PDF worked best.
• To update the data, you must return to the source program, edit the data, re-export the graphic file, and update the graphic in the InDesign layout. Most times the placement of text labels and legends remains intact, but not always.
• The font sizes and text placement vary from chart to chart. For consistency, we use only the graphic from these programs and then lay in the text labels and legends in InDesign. It's been the only method that produces a satisfactory professional result

Claquos and Chartwell are sweet plug-ins but they lack the range and depth of data visualization required by our clients. They really only work with pie charts. As much as I would really love to live my design career with pies (blueberry and pumpkin, especially), clients won't let me. I must also do all the other charts described above.

Datylon (plug-in for Illustrator), Chartbot, and Cacidi Charts all have interesting features and capabilities. They are still in our shop's testing phase, but with a bit more development (or easier charts on our end), they're worthy of a try.

• Datylon has 3 versions: online web chart generator, plug-in for Illustrator, and plug-in for PowerPoint. Extensive templates and chart types. Customizable. Exports to PDF, PNG, SVG.
• Chartbot is intended to quickly create a lot of automated charts for database-intensive publications. Works within InDesign, but the design appears to be limited.
• Cacidi Charts is one of the more promising programs. Plug-in for InDesign lets you design charts directly in the layout file. Nice control of fonts, colors, positioning, but covers only 10 basic styles of charts. For our projects, this is the most promising program.

DeltaGraph is a old standby in the STEM world of data. Has the most extensive library of graph types, but design control is limited. We haven't needed to use it in a while, so I'm not as familiar with its ins and outs.

New kid on the block: Vengage Charts looks like a Canva knock-off (gosh, never thought I'd ever say those words together!). Some cute features for heavily-designed basic chart types. But they do scream "I'M A CANVA DESIGN" even though this online web app is not Canva.  Can be downloaded/exported as HTML, PDF, PNG, and PPT (PowerPoint slide).

Which leaves us with...Illustrator. But it too is limited (can't create stacked 100% column/bar, bar/line combos, candlestick, and scatter graphs). But then again, the majority of the basic chart types are there. And the data is editable, as long as you don't delete the data or convert the live chart to a static graphic. Or touch it in any way. Or breathe on it.

Downsides:

• Someone earlier mentioned that the chart module hasn't changed much since the early 1990s. That's not correct: IMHO and experience, it hasn't changed at all since it was originally released. It. Is. An. Ancient App! Clunky as he!! to use. We have to do massive charts every few months for clients and I just can't retain the idiosyncratic do's and don'ts and mouseclicks to get through the process: so I've recorded several hours of videos for my staff to review before they begin the task.
• Yes, you can edit the data. But...if you've move the labels or legend or changed a bar or pie slice, things will fly all over the artboard (and off it) when the data is updated.
• It's really difficult and clunky to adjust the vertical and horizontal grids, markers along the sides and top/bottom.
• It's clunky to rotate pie charts to get the appearance you want.  *&^%$#@!*
• Controlling the appearance of data point markers is nearly impossible. We make the marker/symbols by hand and manually overlay them on the chart.
• You're constantly reminded by the client that they're able to easily do all this in Excel. And you're repeatedly asked by the client why it's taking you so long to just change the pie slice values. Geeze Louise. Whats wrong with you?!
• Illustrator's chart module has an exceptionally high 4-letter-word factor when used, and often necessitates additional substances to appease the designer: double-espresso cafes, brownies, vodka neat, hourly Taco Bell deliveries, etc. Be sure to build these additional costs into your estimates to clients. And make sure the children are kept in a safe place, out of earshot. Better yet, send them to camp or the grandparents' the week you're working on Illustrator charts.

Hope this helps my fellow designers!

[Scott Falkner]

I regret that I have but one upvote to give to this post.

[Robert at ID-Tasker]

You forgot about my ID-Tasker - if there will be enough people interested - I can make it a priority - and sky will be the limit...