• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Excel data intermittently pastes into one cell in chart data spreadsheet

Explorer ,
Aug 16, 2019 Aug 16, 2019

Copy link to clipboard

Copied

I have a large number of charts to produce in Illustrator and the data has been supplied as Google Sheets. When I try to paste rows of data into the Line Charts or Column Charts, sometimes it pastes into a single cell, rather than into rows, other times it works fine. I've tried a number of work arounds, inc exporting Google Sheet to Excel, pasting the data into Illustrator using text tool first. The only way that works reliably is to export as a tab delimited file and then use the import function in the Chart Data interface. This will take me a long time to set up for each chart I need to produce.

I'm using Version 23.0.6 on Mac OS 10.13

Any assistance greatly appreciated.

Views

1.3K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

New Here , Nov 29, 2022 Nov 29, 2022

I had this issue also, until i realised that CAPS LOCK causes this to ocur.

Votes

Translate

Translate
Adobe
Community Expert ,
Aug 16, 2019 Aug 16, 2019

Copy link to clipboard

Copied

The chart function is a dinosaur compared to Google Sheets.

So there's probably not a lot you can do about it.

Does the data paste well into an Excel chart?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Aug 16, 2019 Aug 16, 2019

Copy link to clipboard

Copied

Yes, it's fine. I've exported from Sheets to a .xlsx file.

It's just incredibly flaky – It will work one time and then not the next, and the next, and the next ... and then start working again. So frustrating and I'll blow my budget if I have to manually reconfigure the data into individual tab delimited files to import into the Graph Data interface.

I'm dying here.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 16, 2019 Aug 16, 2019

Copy link to clipboard

Copied

adamk93229702  schrieb


It's just incredibly flaky –

That describes the nature of the charts function pretty well.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Aug 16, 2019 Aug 16, 2019

Copy link to clipboard

Copied

I'm assuming that the data that works is different than the data that does not work, right? or is it the same data that sometimes work and sometimes it doesn't?

if the former then, maybe the supplied data has different format. Try removing formatting in Google Sheets before copying to see if that helps.

I couldn't reproduce your issue unfortunately. I'm on Windows and it works fine with the simple test I made.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Nov 29, 2022 Nov 29, 2022

Copy link to clipboard

Copied

I had this issue also, until i realised that CAPS LOCK causes this to ocur.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 18, 2023 May 18, 2023

Copy link to clipboard

Copied

Paul,

 

you're the best... Thanks

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
May 19, 2023 May 19, 2023

Copy link to clipboard

Copied

LATEST

Hey Pedro, it's a life saver right! Glad to assist with your charts.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines