When I enter a number like 1839986 in a cell, Illustrator rounds it to 1839990. It is even worse for numbers with more digits.

I need to produce infographics on a constant basis. What's the remedy?

  • Why do you use illustrator to make graphs?
    – joojaa
    Commented Aug 16, 2019 at 5:18
  • Because I need to produce printable CMYK infographics from Excel data, and Excel's "design capabilities" are insufficient for my purpose Commented Aug 24, 2019 at 22:05
  • Yes but there are way more graphing applications than excel. That are also way more suited to your job. You can bark up this tree as much as you want it is not going top change. If your primary job is info graphics get one of the free or not so free scientific visualization applications a spin.
    – joojaa
    Commented Aug 25, 2019 at 8:49
  • Well, I'm not using Excel. The corporate data comes from Excel. I'm using Adobe Illustrator and Adobe InDesign to produce large corporate reports. That Adobe software made for handling data is apparently incapable of handling data correctly is amateurish. So, which CMYK workflow applications for graphing data that work well with InDesign are there? Commented Sep 2, 2019 at 16:52
  • maybe tikz, or write your own in PostScript (really adobes graph tool takes an hour to best from 0 level). but changing color should be your last concern. I would suggest mathematica for all ones graphing needs but something tells me you can not afford it.
    – joojaa
    Commented Sep 2, 2019 at 17:06

1 Answer 1


Use it as is. Only programmers have a theoretical possibility to increase Illustrator's internal calculation & number presentation resolution.

If your units were usual screen pixels, your image would be about 639 meters wide or high. That's for 4 px error. One pixel error needs about 160 meters. I guess this big screens with 72 DPI resolution are still unavailable.

Have the exact numbers stored elsewhere just in case they are needed for something, for ex. if one wants to divide them to prime numbers.

  • Pardon me, but this is not about screen pixels or image sizes, but Illustrator's graph tool rounding numbers in cells when producing infographics (charts). When designing financial publications for SEC filings, for example, numbers must be correct, not approximated Commented Aug 24, 2019 at 22:08
  • Nobody has claimed it's about pixels or image size. The internal number presentation in programs rarely is as typed numbers in normal 10 digit system, internally programs use binary integers or binary floating point numbers. That's for math efficiency. The external form isn't stored, so you must do it by yoursjälv. Number system conversion inaccuracy doesn't cause visible drawing errors. for colors and curves, that was my pixel talk.
    – user82991
    Commented Aug 25, 2019 at 8:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.