1 Reply Latest reply on Nov 28, 2012 7:21 AM by Alex Kerin

    Beginner Question: Import format

    Richard King

      I am importing a large amount of data from Excel that contains Countries, Years, and Series (e.g. various World Bank World Development Indicators, for all countries in the world, for 1960-2011). I have formatted the imported data into the following columns: Country, Series, Year, Value, so each indicator is named in the series column.

       

      How do I, for example, create a scatter-plot where the x and y axes are two of my series (both currently imported in the same column)? Do I need to reformat the data so each series is a different column?

       

      Thanks