We all know it. So what do you guys do to circumvent it. It looks like excel charts copied into illustrator is one way.
We are experiencing a problem with that though, (using numbers on mac not excel) it is "fudging" some of the data points if there is a large number of them. For our purposes this is unacceptable.
Ultimately the data needs to be in indesign anyway so if there are ways for charts to be generated in indesign, that'd be optimal, but I know where I can draw the line. Here is what I'm dealing with:
I'm certain I'm not the only one with this mess of a situation so what are people doing to fix it? Indesign and Illustrator options welcome. Different softwar for creating charts, or plugin options are welcome. Just tell me what you do to deal with this I don't care what the solution is. I'm just at a complete loss here.
Learn Mathematica/ MathLab and use their scripting languages to create a template project or use their built-in CSV/ XLSX importers. Opens up tons of possibilities and they can render this stuff even to 3D-ish SVGs which you than can easily convert and refine in AI. The cheapest option would be to get a home license of Mathematica to learn this stuff, then move on to a commercial license. MathLab and EasyStat are much more expensive and are more aimed at professionals and industrial/ scientific applications, but depending on your workflows might still be worth considering...
You might also check out DeltaGraph.
It's $300. I used to be a heavy user of it a decade ago for scientific and financial work, and thought it was great. I would eagerly go back it if I had the need for it. (Have been making-do with Illustrator since, in order to collaborate with other users.)