- [Instructor] In this movie,
I'll show you how to modify a column of data
to create a category axis.
The idea is right now we're just modifying all of the data,
including the years.
So, we're starting at zero and going all the way up to 2500.
What we really want to do is start at zero and end at 100%
down here on what is known as the value axis.
Then, we want the years to appear
along this vertical category axis.
And, to make that happen, you'll want to click on the graph
in order to select it
and then right-click anywhere in the document window
and choose the Data command,
in order to bring up the floating spreadsheet.
Now, notice that currently all of my values have two digits
after the decimal point and they're all zeros,
meaning that they're not serving any purpose.
To reformat your numbers,
go ahead and click on this icon right here, Cell style,
and that's going to affect all the cells, by the way.
Then, take the Number of decimals value down to zero digits
and just make the columns a little wider.
Change this Column width value to eight digits and click OK
and notice that affects how all the data is listed
in the spreadsheet.
It does not, however, affect the graph,
so if I were to click on the checkmark,
nothing happens inside the document window.
All right, now notice that every item
in the first row is treated as a label in the legend,
so if I don't want a year legend,
then I would just get rid of the word, Year, right there
and then press the Enter key or the Return key on a Mac
to accept that change.
At which point, now if I click on Apply,
this final item is no longer labeled.
I still have a little bit of point text at this location,
but it's currently empty.
That's not what I want either.
What I want to do is tell Illustrator
to stop graphing the years
and you do that by clicking in front of one of the years
up here in the text entry field
and then entering a double-quote character,
which means you press Shift + Quote on an American keyboard
and then press the Enter key or the Return key on a Mac
and now notice that if I, once again, click on a checkmark,
that I get rid of this first bar.
All right, now click in front of 2022
and I'll enter a double-quote and I'll go ahead
and press the Enter key or the Return key on a Mac.
And I'll click in front of 2024 in the text entry field,
by the way.
You can't modify your values directly inside the cells.
So, then, I'll go ahead and enter another double-quote
in front of that guy and I'll click the checkmark,
in order to update the graph.
And you can see that Illustrator is getting the picture.
In fact, it's gone ahead
and stopped graphing all of the years, including 2026,
but I'm not seeing that year expressed
along the vertical category axis.
And so, if I want that to occur,
then I need to make sure to select 2026,
click in front of it up there in the text entry field,
enter a double-quote, and press the Enter key
or the Return key on the Mac.
And then, finally, I need to go ahead
and click on the checkmark
in order to update the category axis
and I end up with this effect here.
So notice that the value axis has changed as well.
We're starting at zero and we're ending at 100,
just as you would expect
when working with percentage values.
And we're down to just five items inside the legend.
Now the black bars still happen to be very long,
but that's because Facebook is much more popular
than the other social media sites,
which is actually true, by the way, in case you're curious.
And that, my friends, is how you change an entire column
of data to a category axis, by entering double-quote marks
in front of the years here inside Illustrator.