1

00:00:00.05 --> 00:00:01.04

- [Instructor] In this movie,



2

00:00:01.04 --> 00:00:03.02

I'll show you how to

modify a column of data



3

00:00:03.02 --> 00:00:06.01

to create a category axis.



4

00:00:06.01 --> 00:00:10.03

The idea is right now we're

just modifying all of the data,



5

00:00:10.03 --> 00:00:12.04

including the years.



6

00:00:12.04 --> 00:00:16.06

So, we're starting at zero and

going all the way up to 2500.



7

00:00:16.06 --> 00:00:21.01

What we really want to do is

start at zero and end at 100%



8

00:00:21.01 --> 00:00:24.02

down here on what is

known as the value axis.



9

00:00:24.02 --> 00:00:25.07

Then, we want the years to appear



10

00:00:25.07 --> 00:00:28.07

along this vertical category axis.



11

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

And, to make that happen, you'll

want to click on the graph



12

00:00:31.01 --> 00:00:32.05

in order to select it



13

00:00:32.05 --> 00:00:35.00

and then right-click anywhere

in the document window



14

00:00:35.00 --> 00:00:36.06

and choose the Data command,



15

00:00:36.06 --> 00:00:39.05

in order to bring up the

floating spreadsheet.



16

00:00:39.05 --> 00:00:43.00

Now, notice that currently all

of my values have two digits



17

00:00:43.00 --> 00:00:46.01

after the decimal point

and they're all zeros,



18

00:00:46.01 --> 00:00:48.07

meaning that they're

not serving any purpose.



19

00:00:48.07 --> 00:00:50.01

To reformat your numbers,



20

00:00:50.01 --> 00:00:53.02

go ahead and click on this

icon right here, Cell style,



21

00:00:53.02 --> 00:00:56.07

and that's going to affect

all the cells, by the way.



22

00:00:56.07 --> 00:01:01.00

Then, take the Number of decimals

value down to zero digits



23

00:01:01.00 --> 00:01:03.02

and just make the columns a little wider.



24

00:01:03.02 --> 00:01:07.03

Change this Column width value

to eight digits and click OK



25

00:01:07.03 --> 00:01:10.00

and notice that affects

how all the data is listed



26

00:01:10.00 --> 00:01:11.03

in the spreadsheet.



27

00:01:11.03 --> 00:01:13.02

It does not, however, affect the graph,



28

00:01:13.02 --> 00:01:15.01

so if I were to click on the checkmark,



29

00:01:15.01 --> 00:01:18.07

nothing happens inside

the document window.



30

00:01:18.07 --> 00:01:20.03

All right, now notice that every item



31

00:01:20.03 --> 00:01:24.02

in the first row is treated

as a label in the legend,



32

00:01:24.02 --> 00:01:26.06

so if I don't want a year legend,



33

00:01:26.06 --> 00:01:29.08

then I would just get rid of

the word, Year, right there



34

00:01:29.08 --> 00:01:32.00

and then press the Enter key

or the Return key on a Mac



35

00:01:32.00 --> 00:01:33.03

to accept that change.



36

00:01:33.03 --> 00:01:35.07

At which point, now if I click on Apply,



37

00:01:35.07 --> 00:01:38.03

this final item is no longer labeled.



38

00:01:38.03 --> 00:01:41.02

I still have a little bit of

point text at this location,



39

00:01:41.02 --> 00:01:43.04

but it's currently empty.



40

00:01:43.04 --> 00:01:44.07

That's not what I want either.



41

00:01:44.07 --> 00:01:46.08

What I want to do is tell Illustrator



42

00:01:46.08 --> 00:01:48.09

to stop graphing the years



43

00:01:48.09 --> 00:01:52.03

and you do that by clicking

in front of one of the years



44

00:01:52.03 --> 00:01:54.08

up here in the text entry field



45

00:01:54.08 --> 00:01:57.06

and then entering a

double-quote character,



46

00:01:57.06 --> 00:02:00.09

which means you press Shift +

Quote on an American keyboard



47

00:02:00.09 --> 00:02:03.07

and then press the Enter key

or the Return key on a Mac



48

00:02:03.07 --> 00:02:06.03

and now notice that if I, once

again, click on a checkmark,



49

00:02:06.03 --> 00:02:09.04

that I get rid of this first bar.



50

00:02:09.04 --> 00:02:12.01

All right, now click in front of 2022



51

00:02:12.01 --> 00:02:15.00

and I'll enter a double-quote

and I'll go ahead



52

00:02:15.00 --> 00:02:17.03

and press the Enter key or

the Return key on a Mac.



53

00:02:17.03 --> 00:02:20.06

And I'll click in front of

2024 in the text entry field,



54

00:02:20.06 --> 00:02:21.05

by the way.



55

00:02:21.05 --> 00:02:24.05

You can't modify your values

directly inside the cells.



56

00:02:24.05 --> 00:02:26.09

So, then, I'll go ahead and

enter another double-quote



57

00:02:26.09 --> 00:02:30.01

in front of that guy and

I'll click the checkmark,



58

00:02:30.01 --> 00:02:31.07

in order to update the graph.



59

00:02:31.07 --> 00:02:35.01

And you can see that Illustrator

is getting the picture.



60

00:02:35.01 --> 00:02:36.09

In fact, it's gone ahead



61

00:02:36.09 --> 00:02:41.05

and stopped graphing all of

the years, including 2026,



62

00:02:41.05 --> 00:02:43.05

but I'm not seeing that year expressed



63

00:02:43.05 --> 00:02:46.01

along the vertical category axis.



64

00:02:46.01 --> 00:02:48.00

And so, if I want that to occur,



65

00:02:48.00 --> 00:02:50.09

then I need to make sure to select 2026,



66

00:02:50.09 --> 00:02:53.07

click in front of it up there

in the text entry field,



67

00:02:53.07 --> 00:02:56.01

enter a double-quote,

and press the Enter key



68

00:02:56.01 --> 00:02:57.06

or the Return key on the Mac.



69

00:02:57.06 --> 00:02:59.02

And then, finally, I need to go ahead



70

00:02:59.02 --> 00:03:00.05

and click on the checkmark



71

00:03:00.05 --> 00:03:03.07

in order to update the category axis



72

00:03:03.07 --> 00:03:05.06

and I end up with this effect here.



73

00:03:05.06 --> 00:03:09.03

So notice that the value

axis has changed as well.



74

00:03:09.03 --> 00:03:12.04

We're starting at zero

and we're ending at 100,



75

00:03:12.04 --> 00:03:13.08

just as you would expect



76

00:03:13.08 --> 00:03:17.02

when working with percentage values.



77

00:03:17.02 --> 00:03:21.05

And we're down to just five

items inside the legend.



78

00:03:21.05 --> 00:03:24.03

Now the black bars still

happen to be very long,



79

00:03:24.03 --> 00:03:26.09

but that's because Facebook

is much more popular



80

00:03:26.09 --> 00:03:29.07

than the other social media sites,



81

00:03:29.07 --> 00:03:33.06

which is actually true, by the

way, in case you're curious.



82

00:03:33.06 --> 00:03:37.03

And that, my friends, is how

you change an entire column



83

00:03:37.03 --> 00:03:41.08

of data to a category axis,

by entering double-quote marks



84

00:03:41.08 --> 00:03:45.07

in front of the years

here inside Illustrator.