+ Reply to Thread
Results 1 to 4 of 4

importing data and create chart

  1. #1
    Registered User
    Join Date
    01-14-2014
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    importing data and create chart

    I need to import a set of point coordinates in excel, contained in a .txt file, and then create the xy chart. I tried several times but can not seem to create the chart. I know the procedure, but I must be wrong.

    I ask you if you can pass directly to the excel file with the chart created, this is something very important and urgent!

    This is the file with the coordinates of the points: https://www.dropbox.com/s/m8mhuq21452uo66/DATI.txt

  2. #2
    Registered User
    Join Date
    01-08-2014
    Location
    Irvine, CA ,USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: importing data and create chart

    Chart.jpg

    Open the text file in Excel.
    Use Text to Columns to create 2 columns of numbers.
    Create chart.

  3. #3
    Registered User
    Join Date
    01-14-2014
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: importing data and create chart

    thanks

    now I need the same type of chart for the following points: https://www.dropbox.com/s/x6axug02hybspym/DATI2.txt

    Can anyone do it?

  4. #4
    Registered User
    Join Date
    01-08-2014
    Location
    Irvine, CA ,USA
    MS-Off Ver
    Excel 2010
    Posts
    23

    Re: importing data and create chart

    Chart2.jpg

    Here is the chart.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Importing a list to create an excel based organization chart
    By jackmoe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2013, 11:26 PM
  2. Importing XML through VBA macro, create schema based on xml source data
    By foxyfmu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-03-2013, 01:18 PM
  3. create a chart with variable Chart data
    By demuro1 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-06-2008, 08:54 AM
  4. [SOLVED] Chart data file lost - need to re-create from chart?
    By LostExcelData in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-07-2006, 03:00 PM
  5. Importing data from several sheets, to one chart
    By Martin Thorgaard in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-06-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1