1

00:00:00.06 --> 00:00:01.08

- [Instructor] Alright so far we have



2

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

a relatively narrow graph.



3

00:00:03.08 --> 00:00:06.08

We want something much bigger and meatier



4

00:00:06.08 --> 00:00:09.00

like this final effect here.



5

00:00:09.00 --> 00:00:11.00

Problem is we can't really get there



6

00:00:11.00 --> 00:00:13.05

just by transforming what we have,



7

00:00:13.05 --> 00:00:16.06

because notice, if I click

on the graph to select it,



8

00:00:16.06 --> 00:00:18.02

and then I grab my scale tool,



9

00:00:18.02 --> 00:00:20.01

which I can get by pressing the S key,



10

00:00:20.01 --> 00:00:23.07

I might click over here in

order to set the origin point



11

00:00:23.07 --> 00:00:25.09

and then move my cursor

over to the right side



12

00:00:25.09 --> 00:00:28.02

and drag while pressing the shift key,



13

00:00:28.02 --> 00:00:31.07

so that I'm scaling the graph

exclusively horizontally.



14

00:00:31.07 --> 00:00:35.07

You can see what happens, I

end up stretching everything



15

00:00:35.07 --> 00:00:39.06

including not only the graph

designs, but the text as well.



16

00:00:39.06 --> 00:00:41.07

And so really your only choice,



17

00:00:41.07 --> 00:00:43.08

if you want the graph

to be a different size,



18

00:00:43.08 --> 00:00:47.00

unless you're going to scale

it absolutely proportionally,



19

00:00:47.00 --> 00:00:49.01

is to recreate the graph from scratch,



20

00:00:49.01 --> 00:00:50.06

and I know that sounds horrible,



21

00:00:50.06 --> 00:00:52.07

but it actually goes pretty quickly.



22

00:00:52.07 --> 00:00:54.08

And so I'm going to

select the graph I have



23

00:00:54.08 --> 00:00:56.06

and I'm going to press the backspace key



24

00:00:56.06 --> 00:00:58.07

or the delete key on

a Mac to get rid of it



25

00:00:58.07 --> 00:01:02.08

and then I'll go ahead and

select that column graph tool



26

00:01:02.08 --> 00:01:06.09

once again and then instead

of dragging, I'll click



27

00:01:06.09 --> 00:01:09.05

in order to bring up

the graph dialogue box



28

00:01:09.05 --> 00:01:12.01

and then I'll set the

width value to 850 points



29

00:01:12.01 --> 00:01:14.07

and I'll set the height to 400 points.



30

00:01:14.07 --> 00:01:16.08

How do I know these are the right values?



31

00:01:16.08 --> 00:01:19.06

Because I experimented

until I came up with



32

00:01:19.06 --> 00:01:20.09

something I liked.



33

00:01:20.09 --> 00:01:23.06

Alright now click okay in order to create



34

00:01:23.06 --> 00:01:26.02

that wide graph that

we're seeing right here.



35

00:01:26.02 --> 00:01:27.08

And then here inside the

floating spreadsheet,



36

00:01:27.08 --> 00:01:30.00

I'll click on the import data icon



37

00:01:30.00 --> 00:01:34.08

and I'll go ahead and locate

that 37 pictographs folder,



38

00:01:34.08 --> 00:01:36.00

I'll scroll down the list,



39

00:01:36.00 --> 00:01:40.05

and I'll find this guy right

here, years with quotes.txt



40

00:01:40.05 --> 00:01:41.09

and that way we won't have to enter quotes



41

00:01:41.09 --> 00:01:45.01

in front of all of the years.



42

00:01:45.01 --> 00:01:47.02

Alright now I'll just go ahead

and click on the check mark



43

00:01:47.02 --> 00:01:49.05

in order to update the graph.



44

00:01:49.05 --> 00:01:51.09

And I want you to notice

that all of those graph



45

00:01:51.09 --> 00:01:55.06

type settings that we applied

earlier have been repeated,



46

00:01:55.06 --> 00:01:58.09

and so for example, each

column is 100% wide,



47

00:01:58.09 --> 00:02:00.09

the clusters are 90% wide,



48

00:02:00.09 --> 00:02:04.08

our legend is up here at the

top of the graph and so forth.



49

00:02:04.08 --> 00:02:06.08

Alright now, go up here

to the control panel



50

00:02:06.08 --> 00:02:09.02

and I'll change the

type size to 12 points,



51

00:02:09.02 --> 00:02:11.09

and I'll go ahead and press the A key



52

00:02:11.09 --> 00:02:13.08

to switch to my white arrow tool.



53

00:02:13.08 --> 00:02:16.00

Then I'll click off the

graph to deselect it



54

00:02:16.00 --> 00:02:18.01

then I'll just go ahead

and marquis the years.



55

00:02:18.01 --> 00:02:22.06

And I'll take their type

size up to 18 points like so.



56

00:02:22.06 --> 00:02:24.04

Alright now I'll just go

ahead and press the V key



57

00:02:24.04 --> 00:02:26.00

to switch back to my black arrow tool



58

00:02:26.00 --> 00:02:28.07

and I'll drag this guide down a little bit



59

00:02:28.07 --> 00:02:32.04

so that I can see all of the legend,



60

00:02:32.04 --> 00:02:34.05

and that's going to

require me to zoom out.



61

00:02:34.05 --> 00:02:36.01

And then I'll go ahead and press the A key



62

00:02:36.01 --> 00:02:38.01

to switch to my white arrow tool



63

00:02:38.01 --> 00:02:40.02

and I'll click off the

shapes to deselect them



64

00:02:40.02 --> 00:02:42.03

and I'll click and shift click



65

00:02:42.03 --> 00:02:46.01

on each one of these rectangles

up here in the legend.



66

00:02:46.01 --> 00:02:48.03

And I'll press shift up

arrow a bunch of times



67

00:02:48.03 --> 00:02:50.02

in order to move them upward.



68

00:02:50.02 --> 00:02:52.02

And then I'll click on the word Facebook,



69

00:02:52.02 --> 00:02:55.00

and I'll alter option click on it again



70

00:02:55.00 --> 00:02:58.03

to select all the text

associated with the legend,



71

00:02:58.03 --> 00:03:00.08

and I'll move those guys up as well.



72

00:03:00.08 --> 00:03:02.04

Alright now here comes the painful part,



73

00:03:02.04 --> 00:03:06.03

we need to apply all those graph

designs over and over again



74

00:03:06.03 --> 00:03:08.07

The easiest way to do

that is to press the V key



75

00:03:08.07 --> 00:03:10.05

to switch back to the black arrow tool,



76

00:03:10.05 --> 00:03:13.02

click on the graph to

select the entire thing,



77

00:03:13.02 --> 00:03:15.02

and then right click anywhere

in the document window



78

00:03:15.02 --> 00:03:17.01

and choose column.



79

00:03:17.01 --> 00:03:20.00

And now I'll go ahead and select Facebook,



80

00:03:20.00 --> 00:03:22.01

I'll change the column type to repeating,



81

00:03:22.01 --> 00:03:24.06

I want rotate legend design off.



82

00:03:24.06 --> 00:03:28.02

I'll go ahead and set each

design represents to 10 units



83

00:03:28.02 --> 00:03:31.07

this time around, so a

full 10 percentage points.



84

00:03:31.07 --> 00:03:34.08

And then I'll set for

fractions to chop design,



85

00:03:34.08 --> 00:03:39.01

and I'll click okay, and we

end up with this effect here.



86

00:03:39.01 --> 00:03:41.00

Now this is the point at which I notice



87

00:03:41.00 --> 00:03:43.06

that things were packed way too tightly,



88

00:03:43.06 --> 00:03:44.07

and we don't really need to compare



89

00:03:44.07 --> 00:03:46.05

four different years of results.



90

00:03:46.05 --> 00:03:48.01

So I'm just going to

right click once again



91

00:03:48.01 --> 00:03:50.08

in the document window, choose data,



92

00:03:50.08 --> 00:03:55.03

and then I'll drag from 2022

all the way over here to 36,



93

00:03:55.03 --> 00:03:57.07

so I'm selecting these three rows,



94

00:03:57.07 --> 00:04:01.01

and I'll press control X or

command X on a Mac to cut them.



95

00:04:01.01 --> 00:04:04.04

And then I'll click on 2020

and I'll press control V



96

00:04:04.04 --> 00:04:06.04

or command V on a Mac to paste.



97

00:04:06.04 --> 00:04:08.00

And that just goes ahead and gets rid of



98

00:04:08.00 --> 00:04:09.04

the first row of numbers,



99

00:04:09.04 --> 00:04:11.01

at which point I'll

click on the check mark



100

00:04:11.01 --> 00:04:12.05

to apply that change.



101

00:04:12.05 --> 00:04:16.01

And you can see, now all the

icons are fitting quite nicely.



102

00:04:16.01 --> 00:04:18.08

At which point, I'll go ahead

and close the spreadsheet.



103

00:04:18.08 --> 00:04:19.09

Alright now I'll press the A key



104

00:04:19.09 --> 00:04:21.08

to switch back to my white arrow tool,



105

00:04:21.08 --> 00:04:23.09

and I'll click off the

graph to deselect it



106

00:04:23.09 --> 00:04:27.07

and I'll alt click on this

F next to the word Instagram



107

00:04:27.07 --> 00:04:31.06

three times, that's an option

click three times on a Mac,



108

00:04:31.06 --> 00:04:34.01

enter to select all

those Instagram columns,



109

00:04:34.01 --> 00:04:35.09

then you want to go to the object menu,



110

00:04:35.09 --> 00:04:38.06

choose graph and choose column.



111

00:04:38.06 --> 00:04:41.04

And now select Instagram and click okay.



112

00:04:41.04 --> 00:04:43.04

Alright now click off

the graph to deselect it



113

00:04:43.04 --> 00:04:46.03

and alt or option click three times



114

00:04:46.03 --> 00:04:48.05

on the F next to LinkedIn



115

00:04:48.05 --> 00:04:50.06

in order to select all

the LinkedIn columns



116

00:04:50.06 --> 00:04:52.09

then return to the object

menu, choose graph,



117

00:04:52.09 --> 00:04:56.05

and choose column, select

LinkedIn this time around,



118

00:04:56.05 --> 00:04:58.02

and click okay.



119

00:04:58.02 --> 00:04:59.05

Alright now click off the graph,



120

00:04:59.05 --> 00:05:03.02

alt or option click on

the F next to Pinterest



121

00:05:03.02 --> 00:05:05.09

three times in order

to select it's columns.



122

00:05:05.09 --> 00:05:09.04

Return to the object menu,

choose graph, choose column,



123

00:05:09.04 --> 00:05:13.04

and select Pinterest and then click okay.



124

00:05:13.04 --> 00:05:15.09

And then finally you want

to click off the graph



125

00:05:15.09 --> 00:05:20.02

to deselect it and alt or

option click three times



126

00:05:20.02 --> 00:05:22.09

on this final F over here

in the top right corner



127

00:05:22.09 --> 00:05:26.02

of the document to select

all of the Twitter columns,



128

00:05:26.02 --> 00:05:29.00

and then for the last time,

go to the object menu,



129

00:05:29.00 --> 00:05:31.04

choose graph, and choose column,



130

00:05:31.04 --> 00:05:35.01

and then select Twitter and click okay.



131

00:05:35.01 --> 00:05:37.04

Alright now we want to

make some adjustments



132

00:05:37.04 --> 00:05:38.02

to the text here.



133

00:05:38.02 --> 00:05:42.00

I'm going to alt click

or option click on a Mac



134

00:05:42.00 --> 00:05:45.03

on 80% and then I'll alt

or option click again.



135

00:05:45.03 --> 00:05:47.08

So again you want to do that slowly,



136

00:05:47.08 --> 00:05:49.07

in other words you don't

want to double click,



137

00:05:49.07 --> 00:05:53.00

and then I'll just go ahead

and nudge this guy up and over



138

00:05:53.00 --> 00:05:54.06

until we have alignment



139

00:05:54.06 --> 00:05:56.09

so that I'm sure all

these guys are centered.



140

00:05:56.09 --> 00:05:58.06

Then I'll press shift left arrow



141

00:05:58.06 --> 00:06:00.03

in order to move them outward.



142

00:06:00.03 --> 00:06:02.03

Then I'll grab these guys down here



143

00:06:02.03 --> 00:06:04.00

and I don't want to select them that way,



144

00:06:04.00 --> 00:06:07.03

because that ends up selecting

these big clipping masks



145

00:06:07.03 --> 00:06:09.08

around the Instagram logos.



146

00:06:09.08 --> 00:06:11.07

So click off in order to deselect



147

00:06:11.07 --> 00:06:14.02

and alt click once, and then twice,



148

00:06:14.02 --> 00:06:17.02

that's an option click

once and twice on a Mac,



149

00:06:17.02 --> 00:06:19.05

then let's just go ahead and

move these guys up to here



150

00:06:19.05 --> 00:06:22.03

and press shift down arrow

in order to move them



151

00:06:22.03 --> 00:06:24.02

to the proper locations.



152

00:06:24.02 --> 00:06:26.04

Alright now we'll click

off the text to deselect it



153

00:06:26.04 --> 00:06:30.04

and I will turn on my

guides layer for a moment



154

00:06:30.04 --> 00:06:32.05

just so I can see where

the graph wants to live,



155

00:06:32.05 --> 00:06:35.07

and I'll press the V key to

switch to my black arrow tool.



156

00:06:35.07 --> 00:06:37.02

I'll click on the graph to select it,



157

00:06:37.02 --> 00:06:39.05

and I'll drag it by

this point right there,



158

00:06:39.05 --> 00:06:42.05

the bottom left point of

the actual body of the graph



159

00:06:42.05 --> 00:06:45.04

until it snaps into alignment

with this guide intersection



160

00:06:45.04 --> 00:06:46.09

down left.



161

00:06:46.09 --> 00:06:49.06

Alright now I'm going to turn

the guides layer back off



162

00:06:49.06 --> 00:06:51.08

and I'll click off the graph to select it.



163

00:06:51.08 --> 00:06:53.01

One more change we need to make



164

00:06:53.01 --> 00:06:54.07

is to switch back to the white arrow tool



165

00:06:54.07 --> 00:06:58.03

and alt click or option

click on this top line here,



166

00:06:58.03 --> 00:07:01.00

this top horizontal line,

and then do it again,



167

00:07:01.00 --> 00:07:02.09

alt or option click a second time.



168

00:07:02.09 --> 00:07:05.04

Change the line weight to 0.5 points,



169

00:07:05.04 --> 00:07:07.05

click on the second color swatch,



170

00:07:07.05 --> 00:07:08.08

and change the color of the stroke



171

00:07:08.08 --> 00:07:11.04

to the shade of gray where the

red, green, and blue values



172

00:07:11.04 --> 00:07:13.02

are all 128.



173

00:07:13.02 --> 00:07:15.05

Then you want to click off

the lines to deselect them.



174

00:07:15.05 --> 00:07:18.05

Now we got to zoom in

on this guy right here.



175

00:07:18.05 --> 00:07:21.04

Notice this little gray

line inside the black one.



176

00:07:21.04 --> 00:07:23.09

Alt or option click on it to select it



177

00:07:23.09 --> 00:07:26.03

and change it back to black



178

00:07:26.03 --> 00:07:29.04

so that we're not seeing

that double line effect.



179

00:07:29.04 --> 00:07:31.01

And then you can just press control zero



180

00:07:31.01 --> 00:07:34.08

or command zero on a

Mac to center your zoom.



181

00:07:34.08 --> 00:07:36.00

Alright and that's it.



182

00:07:36.00 --> 00:07:38.06

So even though it's a painful fact



183

00:07:38.06 --> 00:07:40.02

that you have to recreate a graph



184

00:07:40.02 --> 00:07:42.05

in order to get it exactly right,



185

00:07:42.05 --> 00:07:44.09

it goes by relatively quickly



186

00:07:44.09 --> 00:07:47.08

and the results are worth that

little extra bit of effort



187

00:07:47.08 --> 00:07:49.08

here inside Illustrator.