- [Instructor] Alright so far we have
a relatively narrow graph.
We want something much bigger and meatier
like this final effect here.
Problem is we can't really get there
just by transforming what we have,
because notice, if I click on the graph to select it,
and then I grab my scale tool,
which I can get by pressing the S key,
I might click over here in order to set the origin point
and then move my cursor over to the right side
and drag while pressing the shift key,
so that I'm scaling the graph exclusively horizontally.
You can see what happens, I end up stretching everything
including not only the graph designs, but the text as well.
And so really your only choice,
if you want the graph to be a different size,
unless you're going to scale it absolutely proportionally,
is to recreate the graph from scratch,
and I know that sounds horrible,
but it actually goes pretty quickly.
And so I'm going to select the graph I have
and I'm going to press the backspace key
or the delete key on a Mac to get rid of it
and then I'll go ahead and select that column graph tool
once again and then instead of dragging, I'll click
in order to bring up the graph dialogue box
and then I'll set the width value to 850 points
and I'll set the height to 400 points.
How do I know these are the right values?
Because I experimented until I came up with
something I liked.
Alright now click okay in order to create
that wide graph that we're seeing right here.
And then here inside the floating spreadsheet,
I'll click on the import data icon
and I'll go ahead and locate that 37 pictographs folder,
I'll scroll down the list,
and I'll find this guy right here, years with quotes.txt
and that way we won't have to enter quotes
in front of all of the years.
Alright now I'll just go ahead and click on the check mark
in order to update the graph.
And I want you to notice that all of those graph
type settings that we applied earlier have been repeated,
and so for example, each column is 100% wide,
the clusters are 90% wide,
our legend is up here at the top of the graph and so forth.
Alright now, go up here to the control panel
and I'll change the type size to 12 points,
and I'll go ahead and press the A key
to switch to my white arrow tool.
Then I'll click off the graph to deselect it
then I'll just go ahead and marquis the years.
And I'll take their type size up to 18 points like so.
Alright now I'll just go ahead and press the V key
to switch back to my black arrow tool
and I'll drag this guide down a little bit
so that I can see all of the legend,
and that's going to require me to zoom out.
And then I'll go ahead and press the A key
to switch to my white arrow tool
and I'll click off the shapes to deselect them
and I'll click and shift click
on each one of these rectangles up here in the legend.
And I'll press shift up arrow a bunch of times
in order to move them upward.
And then I'll click on the word Facebook,
and I'll alter option click on it again
to select all the text associated with the legend,
and I'll move those guys up as well.
Alright now here comes the painful part,
we need to apply all those graph designs over and over again
The easiest way to do that is to press the V key
to switch back to the black arrow tool,
click on the graph to select the entire thing,
and then right click anywhere in the document window
and choose column.
And now I'll go ahead and select Facebook,
I'll change the column type to repeating,
I want rotate legend design off.
I'll go ahead and set each design represents to 10 units
this time around, so a full 10 percentage points.
And then I'll set for fractions to chop design,
and I'll click okay, and we end up with this effect here.
Now this is the point at which I notice
that things were packed way too tightly,
and we don't really need to compare
four different years of results.
So I'm just going to right click once again
in the document window, choose data,
and then I'll drag from 2022 all the way over here to 36,
so I'm selecting these three rows,
and I'll press control X or command X on a Mac to cut them.
And then I'll click on 2020 and I'll press control V
or command V on a Mac to paste.
And that just goes ahead and gets rid of
the first row of numbers,
at which point I'll click on the check mark
to apply that change.
And you can see, now all the icons are fitting quite nicely.
At which point, I'll go ahead and close the spreadsheet.
Alright now I'll press the A key
to switch back to my white arrow tool,
and I'll click off the graph to deselect it
and I'll alt click on this F next to the word Instagram
three times, that's an option click three times on a Mac,
enter to select all those Instagram columns,
then you want to go to the object menu,
choose graph and choose column.
And now select Instagram and click okay.
Alright now click off the graph to deselect it
and alt or option click three times
on the F next to LinkedIn
in order to select all the LinkedIn columns
then return to the object menu, choose graph,
and choose column, select LinkedIn this time around,
and click okay.
Alright now click off the graph,
alt or option click on the F next to Pinterest
three times in order to select it's columns.
Return to the object menu, choose graph, choose column,
and select Pinterest and then click okay.
And then finally you want to click off the graph
to deselect it and alt or option click three times
on this final F over here in the top right corner
of the document to select all of the Twitter columns,
and then for the last time, go to the object menu,
choose graph, and choose column,
and then select Twitter and click okay.
Alright now we want to make some adjustments
to the text here.
I'm going to alt click or option click on a Mac
on 80% and then I'll alt or option click again.
So again you want to do that slowly,
in other words you don't want to double click,
and then I'll just go ahead and nudge this guy up and over
until we have alignment
so that I'm sure all these guys are centered.
Then I'll press shift left arrow
in order to move them outward.
Then I'll grab these guys down here
and I don't want to select them that way,
because that ends up selecting these big clipping masks
around the Instagram logos.
So click off in order to deselect
and alt click once, and then twice,
that's an option click once and twice on a Mac,
then let's just go ahead and move these guys up to here
and press shift down arrow in order to move them
to the proper locations.
Alright now we'll click off the text to deselect it
and I will turn on my guides layer for a moment
just so I can see where the graph wants to live,
and I'll press the V key to switch to my black arrow tool.
I'll click on the graph to select it,
and I'll drag it by this point right there,
the bottom left point of the actual body of the graph
until it snaps into alignment with this guide intersection
down left.
Alright now I'm going to turn the guides layer back off
and I'll click off the graph to select it.
One more change we need to make
is to switch back to the white arrow tool
and alt click or option click on this top line here,
this top horizontal line, and then do it again,
alt or option click a second time.
Change the line weight to 0.5 points,
click on the second color swatch,
and change the color of the stroke
to the shade of gray where the red, green, and blue values
are all 128.
Then you want to click off the lines to deselect them.
Now we got to zoom in on this guy right here.
Notice this little gray line inside the black one.
Alt or option click on it to select it
and change it back to black
so that we're not seeing that double line effect.
And then you can just press control zero
or command zero on a Mac to center your zoom.
Alright and that's it.
So even though it's a painful fact
that you have to recreate a graph
in order to get it exactly right,
it goes by relatively quickly
and the results are worth that little extra bit of effort
here inside Illustrator.