{"id":1346,"date":"2020-09-08T11:08:01","date_gmt":"2020-09-08T09:08:01","guid":{"rendered":"https:\/\/www.everviz.com\/blog\/?p=1346"},"modified":"2022-12-12T21:38:55","modified_gmt":"2022-12-12T21:38:55","slug":"adding-data-to-your-charts-and-maps","status":"publish","type":"post","link":"https:\/\/www.everviz.com\/blog\/adding-data-to-your-charts-and-maps\/","title":{"rendered":"Adding data to your charts and maps"},"content":{"rendered":"\n

This post explains different ways you can get your data into everviz<\/a> to bring your data to life through interactive diagrams<\/p>\n\n\n\n

The following options will be described. Click on any of the links to jump to specific sections:<\/p>\n\n\n\n

    \n
  1. Import a CSV file<\/a><\/li>\n\n\n\n
  2. Copy and paste from a spreadsheet<\/a><\/li>\n\n\n\n
  3. Insert data manually<\/a><\/li>\n\n\n\n
  4. Connect to a Google Spreadsheet<\/a><\/li>\n\n\n\n
  5. Connect to a live data source<\/a><\/li>\n<\/ol>\n\n\n\n


    Whichever way to upload your data you choose, be sure to follow these basic rules:<\/strong><\/p>\n\n\n\n

      \n
    1. Sort the first column (x-axis) in ascending order. i.e. the x-axis data should be arranged from the smallest to the largest number or from the old date to the new date.

      <\/li>\n\n\n\n
    2. Valid date formats: Date values should have a consistent format using one of the following formats:\n
        \n
      1. YYYY\/mm\/dd<\/li>\n\n\n\n
      2. dd\/mm\/YYYY<\/li>\n\n\n\n
      3. mm\/dd\/YYYY<\/li>\n\n\n\n
      4. dd\/mm\/YY<\/li>\n\n\n\n
      5. mm\/dd\/YY<\/li>\n\n\n\n
      6. Number (Unix epoch time in milliseconds)

        <\/li>\n<\/ol>\n<\/li>\n<\/ol>\n\n\n\n

        1. Import a CSV file<\/h2>\n\n\n\n

        A CSV file is a plain text file that stores spreadsheet information as Comma Separated Values.  You can export CSV files from almost any spreadsheet program, such as Microsoft Excel, OpenOffice Calc or Google Sheets.<\/p>\n\n\n\n

        To load a CSV file as the data for your chart, simply click the “Upload” button and select the file from your computer. <\/p>\n\n\n\n

        \"\"<\/figure>\n\n\n\n



        For a smooth data process, make sure that your CSV file respects these five rules:

        <\/h3><\/p>\n\n\n\n

        1. Separate by comma<\/h3>\n\n\n\n

        Be sure that each element of the CSV file is separated by a comma. See the picture below:<\/p>\n\n\n\n

        \"\"\/<\/figure>\n\n\n\n



        2. X values<\/a><\/h3>\n\n\n\n

        The first column represents the x values. See the picture below:<\/p>\n\n\n\n

        \"\"\/<\/figure>\n\n\n\n

        The x values data could be numbers, dates, or categories. See the picture below:<\/p>\n\n\n\n

        \"\"\/<\/figure>\n\n\n\n


        3. Series name<\/h3>\n\n\n\n

        The first line represents the name of the series. See the picture below: <\/p>\n\n\n\n


        4. The values of data series<\/h3>\n\n\n\n

        Columns represent the values of the data series. See the picture below:<\/p>\n\n\n\n

        \"\"\/<\/figure>\n\n\n\n


        5. European CSV<\/h3>\n\n\n\n

        everviz also supports the European CSV using the semicolon to separate data fields instead of the comma. See the picture below:<\/p>\n\n\n\n

        \"\"\/<\/figure>\n\n\n\n

        And the comma as a decimal mark:<\/p>\n\n\n\n

        \"\"\/<\/figure>\n\n\n\n


        2. Copy and paste from a spreadsheet<\/h2>\n\n\n\n

        If you have your data in a spreadsheet application, you can copy and paste the values into everviz.<\/p>\n\n\n\n

        Make sure you put your cursor in the top left cell in the editor before you paste in your data. <\/p>\n\n\n\n