1

00:00:00.06 --> 00:00:01.04

- [Narrator] In this movie



2

00:00:01.04 --> 00:00:04.04

I'll show you how to

import a spreadsheet file.



3

00:00:04.04 --> 00:00:07.09

Now here I happened to be

working inside Microsoft Excel,



4

00:00:07.09 --> 00:00:09.06

but it could just as easily be



5

00:00:09.06 --> 00:00:13.06

Apple's Numbers application

or Google Docs online.



6

00:00:13.06 --> 00:00:15.06

Anything that allows you to save off a



7

00:00:15.06 --> 00:00:18.01

tab-delimited text file.



8

00:00:18.01 --> 00:00:20.01

Now I want to stress

that all of these numbers



9

00:00:20.01 --> 00:00:21.07

are totally made up,



10

00:00:21.07 --> 00:00:23.05

but they do have some structure.



11

00:00:23.05 --> 00:00:26.02

So column A includes a few years,



12

00:00:26.02 --> 00:00:31.00

and then columns B through

F are percentage values.



13

00:00:31.00 --> 00:00:34.05

Now notice that I've saved

the file as an XLS document



14

00:00:34.05 --> 00:00:37.05

which is Excel's old data file format,



15

00:00:37.05 --> 00:00:41.03

which is compatible with just

about every program out there.



16

00:00:41.03 --> 00:00:43.07

Alright, so I'll go ahead and

switch back to Illustrator



17

00:00:43.07 --> 00:00:46.01

and I'll click on a graph

with my black arrow tool



18

00:00:46.01 --> 00:00:48.06

to select it, and then I'll

right click anywhere inside



19

00:00:48.06 --> 00:00:51.05

the document window and choose data.



20

00:00:51.05 --> 00:00:53.07

And now, I want you to notice right next



21

00:00:53.07 --> 00:00:56.06

to the text entry field, we have this icon



22

00:00:56.06 --> 00:00:58.04

labeled import data.



23

00:00:58.04 --> 00:00:59.08

Go ahead and click on it,



24

00:00:59.08 --> 00:01:03.03

and then I'll navigate to

my Exercise Files folder,



25

00:01:03.03 --> 00:01:04.09

which I have on my desktop,



26

00:01:04.09 --> 00:01:08.02

and I'm looking for the

37 pictographs sub folder



27

00:01:08.02 --> 00:01:10.07

at which point I can

see my file right there,



28

00:01:10.07 --> 00:01:13.08

Social media data.xls, and to open it,



29

00:01:13.08 --> 00:01:16.03

I'll just click on the open button.



30

00:01:16.03 --> 00:01:18.09

At which point, I'll see an alert message.



31

00:01:18.09 --> 00:01:20.02

Now the thing you have to bear in mind



32

00:01:20.02 --> 00:01:22.03

about graphing inside Illustrator



33

00:01:22.03 --> 00:01:24.03

is that it's a very old feature.



34

00:01:24.03 --> 00:01:27.07

It was first introduced in Illustrator 5.0



35

00:01:27.07 --> 00:01:31.00

and it really hasn't been

updated much in the years since.



36

00:01:31.00 --> 00:01:32.08

And so as a result, this alert message



37

00:01:32.08 --> 00:01:34.05

may not make a lot of sense.



38

00:01:34.05 --> 00:01:36.09

It says, cannot import the graph data,



39

00:01:36.09 --> 00:01:38.04

alright so far so good,



40

00:01:38.04 --> 00:01:40.05

the file couldn't be found.



41

00:01:40.05 --> 00:01:42.08

Well, we just saw the file a moment ago



42

00:01:42.08 --> 00:01:45.07

so obviously, Illustrator is

able to find it just fine,



43

00:01:45.07 --> 00:01:47.07

the problem is that it's locked



44

00:01:47.07 --> 00:01:50.04

because it's open inside Excel.



45

00:01:50.04 --> 00:01:52.09

And so the solution is

to click the OK button



46

00:01:52.09 --> 00:01:55.01

and then bring Excel up on screen



47

00:01:55.01 --> 00:01:57.04

and go ahead and close that file.



48

00:01:57.04 --> 00:01:59.02

Now back here inside Illustrator,



49

00:01:59.02 --> 00:02:02.02

go ahead and click on the

import data button once again,



50

00:02:02.02 --> 00:02:04.01

then, if you're working along with me,



51

00:02:04.01 --> 00:02:06.06

navigate to that 37 pictographs file



52

00:02:06.06 --> 00:02:10.08

and go ahead and open the

XLS document once again.



53

00:02:10.08 --> 00:02:13.04

At which point, something

truly weird happens.



54

00:02:13.04 --> 00:02:15.09

Now depending on which version

of the program you're using,



55

00:02:15.09 --> 00:02:18.02

you may see an alert

message that tells you,



56

00:02:18.02 --> 00:02:21.03

Illustrator cannot open XLS documents.



57

00:02:21.03 --> 00:02:23.01

But in my version of Illustrator,



58

00:02:23.01 --> 00:02:27.02

I'm seeing this nonsense

text in the very first cell



59

00:02:27.02 --> 00:02:28.04

and then I see



60

00:02:28.04 --> 00:02:31.07

the letter C, in the second cell down,



61

00:02:31.07 --> 00:02:34.08

and if I were to expand the

size of the spreadsheet,



62

00:02:34.08 --> 00:02:37.08

and then scroll down the list right here,



63

00:02:37.08 --> 00:02:40.06

then I'm going to reveal a bunch of



64

00:02:40.06 --> 00:02:42.03

additional weirdness.



65

00:02:42.03 --> 00:02:43.08

And so, what you really want to do is



66

00:02:43.08 --> 00:02:45.01

click on the revert button,



67

00:02:45.01 --> 00:02:47.08

because if you click on

the check mark instead,



68

00:02:47.08 --> 00:02:50.00

you're going to end up getting



69

00:02:50.00 --> 00:02:53.02

this absolute disaster right here.



70

00:02:53.02 --> 00:02:54.08

Notice if I scroll over that,



71

00:02:54.08 --> 00:02:57.05

I've got a lot of garbage going on.



72

00:02:57.05 --> 00:02:59.01

And so to get rid of that stuff,



73

00:02:59.01 --> 00:03:00.05

you want to go up to the Edit menu



74

00:03:00.05 --> 00:03:02.03

and choose the undo command.



75

00:03:02.03 --> 00:03:03.08

Or just press Control + Z



76

00:03:03.08 --> 00:03:05.07

or Command + Z on the Mac.



77

00:03:05.07 --> 00:03:09.00

And if that doesn't work

as it didn't in my case



78

00:03:09.00 --> 00:03:11.08

then you need to close

the spreadsheet like so,



79

00:03:11.08 --> 00:03:14.07

and then return to the

Edit menu and choose



80

00:03:14.07 --> 00:03:17.07

Undo Graph Data OK, or again just press



81

00:03:17.07 --> 00:03:19.09

Control + Z or Command + Z on the Mac,



82

00:03:19.09 --> 00:03:23.00

and that should take care of the problem.



83

00:03:23.00 --> 00:03:25.01

Alright, now I'll go ahead

and right-click again,



84

00:03:25.01 --> 00:03:26.09

once again choose the data command



85

00:03:26.09 --> 00:03:28.08

to revisit the spreadsheet,



86

00:03:28.08 --> 00:03:30.08

and I want to show you something here.



87

00:03:30.08 --> 00:03:33.03

Let's say I click on some cell



88

00:03:33.03 --> 00:03:36.00

other than the first cell

inside the spreadsheet,



89

00:03:36.00 --> 00:03:38.03

and once again click

the import data button



90

00:03:38.03 --> 00:03:41.09

and navigate to that

37 pictographs folder.



91

00:03:41.09 --> 00:03:44.04

This time I want to load this file,



92

00:03:44.04 --> 00:03:47.04

Tab-delimited data.txt,



93

00:03:47.04 --> 00:03:50.09

which is a plain text file in

which each one of the values



94

00:03:50.09 --> 00:03:54.07

is separated from its

neighbors by a tab character.



95

00:03:54.07 --> 00:03:58.01

And that is a standard

export or save option



96

00:03:58.01 --> 00:04:01.08

inside Excel and the other

spreadsheet programs.



97

00:04:01.08 --> 00:04:03.08

Alright so, with that file selected



98

00:04:03.08 --> 00:04:05.08

I'll go ahead and click

on the open button.



99

00:04:05.08 --> 00:04:07.08

Now what I want you to notice here



100

00:04:07.08 --> 00:04:11.06

is that I've gone ahead

and imported the data



101

00:04:11.06 --> 00:04:13.05

at that click point,



102

00:04:13.05 --> 00:04:15.05

which is actually a really useful feature



103

00:04:15.05 --> 00:04:17.05

because it means that you can import



104

00:04:17.05 --> 00:04:20.03

more than one spreadsheet

file if you like.



105

00:04:20.03 --> 00:04:22.03

In my case, it's not

really what I want though,



106

00:04:22.03 --> 00:04:25.01

so I'll just go ahead and drag from year



107

00:04:25.01 --> 00:04:28.07

to this value 36 under the Twitter column,



108

00:04:28.07 --> 00:04:31.01

and I'll press Control + X or Command + X



109

00:04:31.01 --> 00:04:33.03

on the Mac in order to cut that data,



110

00:04:33.03 --> 00:04:36.00

and then I'll go ahead and scroll back



111

00:04:36.00 --> 00:04:39.05

to the very first cell, click

on it in order to select it,



112

00:04:39.05 --> 00:04:41.00

and I'll press Control + V



113

00:04:41.00 --> 00:04:42.05

or Command + V on the Mac,



114

00:04:42.05 --> 00:04:44.03

to paste that cut data.



115

00:04:44.03 --> 00:04:46.06

After which way, I'll

click on the check mark



116

00:04:46.06 --> 00:04:49.07

in order to update my graph.



117

00:04:49.07 --> 00:04:51.06

Alright I think now pretty obviously,



118

00:04:51.06 --> 00:04:54.04

this isn't quite the

effect I'm looking for.



119

00:04:54.04 --> 00:04:57.04

Notice that I'm not only graphing Twitter,



120

00:04:57.04 --> 00:05:00.06

Pinterest, LinkedIn,

Instagram, and Facebook,



121

00:05:00.06 --> 00:05:02.07

I'm also graphing that first column



122

00:05:02.07 --> 00:05:04.06

which are the years.



123

00:05:04.06 --> 00:05:07.00

And because the year

values are so much bigger



124

00:05:07.00 --> 00:05:08.01

than the other ones,



125

00:05:08.01 --> 00:05:11.04

we're ending up with these very long bars



126

00:05:11.04 --> 00:05:15.07

followed by extremely short ones.



127

00:05:15.07 --> 00:05:18.05

And so what we need to

do is modify those years



128

00:05:18.05 --> 00:05:20.02

in order to convert those values



129

00:05:20.02 --> 00:05:23.08

into a category access and

I'll show you how that works,



130

00:05:23.08 --> 00:05:25.07

in the very next movie.