Ignore commas in graph data
I create regional reports with a lot of data visualization, so I copy and paste from excel and google sheets all the time. The amount of time I spend removing commas from each number over 999 while creating graphs is wild. I'm working on finding better workflows for this, but if you could just make commas invisible or intelligible to the data window in Illustrator, I would be so happy!
Ambrose Reed commented
Hey Egor, I have started doing this, thanks!
In cases where the spreadsheet is formatted by a partner for some other purpose, I still have to create a duplicate that I can alter, and then put the commas back in for visual clarity on the other end, so it would still be great to have commas be baked in somehow. Appreciate the suggestion though
Ambrose, why don’t you change the Number Format in your spreadsheet before copying it? Both Excel and Google Sheets allow to reformat your values so that commas are not created.
I agree that Illustrator will benefit from having its own filter, but the workaround exists.