Skip to main content
adamk93229702
adamk93229702
Known Participant
August 16, 2019
Answered

Excel data intermittently pastes into one cell in chart data spreadsheet

  • August 16, 2019
  • 2 replies
  • 2161 views

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.

    This topic has been closed for replies.
    Correct answer Paul2348832544jq

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

    2 replies

    P
    Paul2348832544jqCorrect answer
    Participant
    November 29, 2022

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

      pedro_canha
      pedro_canha
      Participant
      May 18, 2023

      Paul,

       

      you're the best... Thanks

      P
      Paul2348832544jq
      Participant
      May 19, 2023

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

      Monika Gause
      Community Expert
      Monika GauseCommunity Expert
      Community Expert
      August 16, 2019

      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?

      adamk93229702
      adamk93229702Author
      Known Participant
      August 16, 2019

      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.

      Monika Gause
      Community Expert
      Monika GauseCommunity Expert
      Community Expert
      August 16, 2019

      adamk93229702  schrieb


      It's just incredibly flaky –

      That describes the nature of the charts function pretty well.

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices