Start learning with our library of video tutorials taught by experts. Get started

Illustrator CS4 Beyond the Basics

Formatting data


From:

Illustrator CS4 Beyond the Basics

with Mordy Golding

Video: Formatting data

An important part about creating graphs and charts inside of Illustrator is learning how to format the data correctly. So, let's take a few moments to see how we can actually format the data in the Graph Data window to get the results that we want. I am going to simply start with the regular print document here, click OK to accept that and let's start off just by working with the simple column graph. Just draw out an area right over here, let's get the Graph Data window here and let's start typing in some values. Let's say we want to actually compare, let's say the sales of apples and oranges. So, let's start with apples first. Let's say sales are going to be in millions and we'll say we'll do 12 million the first year, 18 million the second year, in the third year, maybe we had a bad year, 8 million and then we earn up to like 34 million, right. So let's say over 4 years. So, now we'll go ahead and we'll look at the oranges here. So let's say maybe the oranges are a little bit more than apples, right. So, let's say we have around 18 the first year, we have about 22 the second year, again we had a pretty bad year so let's say we only have let's say 13 and then for other year we had a really great year, about 45 million.
Expand all | Collapse all
  1. 2m 4s
    1. Welcome
      1m 41s
    2. Using the exercise files
      23s
  2. 33m 20s
    1. Introducing Live Paint
      38s
    2. Drawing in Illustrator
      4m 21s
    3. Creating a Live Paint group
      2m 54s
    4. Using the Live Paint Bucket tool
      3m 17s
    5. Using Live Paint with open paths
      2m 29s
    6. Detecting gaps in Live Paint groups
      4m 17s
    7. Adding paths to a Live Paint group
      3m 41s
    8. Using the Live Paint Selection tool
      5m 44s
    9. Releasing and expanding Live Paint groups
      2m 55s
    10. Understanding how Live Paint groups work
      3m 4s
  3. 49m 36s
    1. Introducing the trace options
      39s
    2. Setting expectations: Live Trace
      2m 26s
    3. Using the Live Trace feature
      1m 51s
    4. Understanding how Live Trace works
      5m 41s
    5. Making raster-based adjustments
      5m 52s
    6. Tracing with fills, strokes, or both
      2m 55s
    7. Making vector-based adjustments
      6m 12s
    8. Adjusting colors in Live Trace
      4m 39s
    9. Using Photoshop with Live Trace
      5m 22s
    10. Releasing and expanding Live Trace artwork
      2m 58s
    11. Saving and exporting Live Trace presets
      2m 36s
    12. Tracing in Batch mode with Adobe Bridge
      1m 35s
    13. Turning an image into mosaic tiles
      2m 28s
    14. Tracing an image manually
      4m 22s
  4. 1h 24m
    1. Introducing 3D
      33s
    2. Setting expectations: 3D in Illustrator
      2m 53s
    3. How fills and strokes affect 3D artwork
      4m 43s
    4. Applying the 3D Extrude & Bevel effect
      6m 25s
    5. Applying a bevel
      5m 40s
    6. Showing the hidden faces of a 3D object
      4m 49s
    7. Applying the 3D Revolve effect
      5m 22s
    8. Visualizing the revolve axis
      3m 5s
    9. Applying the 3D Rotate effect
      1m 35s
    10. Adjusting surface settings
      9m 33s
    11. Understanding the importance of 3D and groups
      3m 24s
    12. Preparing art for mapping
      10m 19s
    13. Mapping artwork to a 3D surface
      14m 21s
    14. Hiding geometry with 3D artwork mapping
      4m 0s
    15. Extending the use of 3D in Illustrator
      8m 7s
  5. 44m 37s
    1. Introducing transformations and effects
      32s
    2. Using the Transform panel
      12m 37s
    3. Repeating transformations
      5m 23s
    4. Using the Transform Each function
      3m 48s
    5. Using the Convert to Shape effects
      5m 49s
    6. Using the Distort & Transform effects
      5m 12s
    7. Using the Path effects
      6m 58s
    8. Using the Pathfinder effects
      4m 18s
  6. 28m 23s
    1. Introducing graphic styles
      33s
    2. Applying graphic styles
      10m 8s
    3. Defining graphic styles
      8m 46s
    4. Previewing graphic styles
      2m 10s
    5. Modifying graphic styles
      3m 30s
    6. Understanding graphic styles for text
      3m 16s
  7. 22m 49s
    1. Introducing advanced masking techniques
      32s
    2. Understanding clipping masks
      7m 15s
    3. Using layer clipping masks
      6m 30s
    4. Creating opacity masks
      8m 32s
  8. 1h 6m
    1. Introducing color
      40s
    2. Considering three types of color swatches
      7m 7s
    3. Managing color groups
      2m 58s
    4. Understanding the HSB color wheel
      3m 57s
    5. Understanding color harmonies
      2m 57s
    6. Using the color guide
      3m 54s
    7. Limiting the color guide
      3m 17s
    8. Modifying color with the Recolor Artwork feature
      6m 25s
    9. Using the Edit tab to adjust color
      5m 44s
    10. Using the Assign tab to replace colors
      8m 37s
    11. Making global color adjustments
      2m 17s
    12. Using Recolor options
      7m 3s
    13. Converting artwork to grayscale
      3m 23s
    14. Simulating artwork on different devices
      3m 18s
    15. Accessing Kuler directly from Illustrator
      2m 7s
    16. Ensuring high contrast for color-blind people
      2m 42s
  9. 53m 19s
    1. Introducing transparency
      40s
    2. Understanding transparency flattening
      2m 31s
    3. Exercising the two rules of transparency flattening
      10m 53s
    4. Understanding complex regions in transparency flattening
      4m 50s
    5. Exploring the transparency flattener settings
      8m 37s
    6. Using transparency flattening and object stacking order
      6m 39s
    7. Using the Flattener Preview panel
      6m 31s
    8. Creating and sharing Transparency Flattener presets
      2m 25s
    9. Working within an EPS workflow
      5m 3s
    10. Understanding the Illustrator and InDesign workflow
      5m 10s
  10. 50m 1s
    1. Introducing prepress and output
      23s
    2. Understanding resolutions
      8m 27s
    3. Discovering RGB and CMYK "gotchas"
      5m 42s
    4. Using Overprints and Overprint Preview
      7m 43s
    5. Understanding "book color" and proofing spot colors
      8m 1s
    6. Collecting vital information with Document Info
      2m 28s
    7. Previewing color separations onscreen
      1m 12s
    8. Making 3D artwork look good
      2m 16s
    9. Seeing white lines and knowing what to do about them
      2m 41s
    10. Creating "bulletproof" press-ready PDF files
      3m 45s
    11. Protecting content with secure PDFs
      2m 48s
    12. Using PDF presets
      2m 47s
    13. Moving forward: The Adobe PDF Print Engine
      1m 48s
  11. 35m 43s
    1. Introducing distortions
      27s
    2. Using the Warp effect
      4m 20s
    3. The Warp effect vs. envelope distortion
      3m 48s
    4. Applying the Make with Warp envelope distortion
      2m 45s
    5. Applying the Make with Mesh envelope distortion
      2m 41s
    6. Applying the Make with Top Object envelope distortion
      3m 45s
    7. Editing envelopes
      5m 0s
    8. Adjusting envelope settings
      4m 2s
    9. Releasing and expanding envelope distortions
      1m 44s
    10. Applying envelope distortions to text
      1m 27s
    11. Using the liquify distortion tools
      3m 5s
    12. Customizing the liquify tools
      2m 39s
  12. 28m 56s
    1. Introducing blends
      32s
    2. Blending two objects
      6m 18s
    3. Adjusting blend options
      5m 47s
    4. Blending anchor points
      5m 36s
    5. Blending three or more objects
      2m 9s
    6. Replacing the spine of a blend
      4m 32s
    7. Reversing the direction of a blend
      2m 15s
    8. Releasing and expanding a blend
      1m 47s
  13. 46m 54s
    1. Introducing charts and graphs
      35s
    2. Setting expectations: Graphs in Illustrator
      3m 19s
    3. Creating a chart
      8m 2s
    4. Importing data
      3m 34s
    5. Formatting data
      5m 1s
    6. Customizing a chart
      10m 21s
    7. Combining chart types
      2m 40s
    8. Creating graph designs
      6m 0s
    9. Styling and updating graphs
      5m 33s
    10. Ungrouping graphs
      1m 49s
  14. 26m 36s
    1. Introducing Gradient Mesh
      23s
    2. Understanding the Gradient Mesh feature
      9m 34s
    3. Using Gradient Mesh to add contoured shading
      6m 14s
    4. Using Gradient Mesh to create photorealistic effects
      10m 25s
  15. 8m 18s
    1. Introducing flare effects
      25s
    2. Drawing a lens flare
      3m 28s
    3. Modifying a lens flare
      1m 27s
    4. Using a mask with lens flares
      2m 58s
  16. 29s
    1. Goodbye
      29s

Watch this entire course now—plus get access to every course in the library. Each course includes high-quality videos taught by expert instructors.

Become a member
Please wait...
Illustrator CS4 Beyond the Basics
9h 42m Intermediate Apr 03, 2009

Viewers: in countries Watching now:

Covering a wide range of topics, from advanced masking to chart creation, Illustrator CS4 Beyond the Basics reveals a whole new level of power, creativity, and efficiency with Illustrator. Instructor Mordy Golding explores how to work with Live Paint groups, get the most out of the Live Trace feature, and take advantage of Illustrator’s wide range of effects. He also discusses advanced transformation techniques, powerful 3D functionality, and important color concepts. Exercise files accompany the course.

Topics include:
  • Tracing artwork both automatically and manually
  • Mapping artwork to complex 3D surfaces
  • Using pressure-sensitive distortion tools
  • Recoloring artwork across a document
  • Using Excel data to create charts and graphs
  • Understanding how transparency really works
  • Creating high-quality, press-ready PDFs
  • Building efficient files with graphic styles
Subject:
Design
Software:
Illustrator
Author:
Mordy Golding

Formatting data

An important part about creating graphs and charts inside of Illustrator is learning how to format the data correctly. So, let's take a few moments to see how we can actually format the data in the Graph Data window to get the results that we want. I am going to simply start with the regular print document here, click OK to accept that and let's start off just by working with the simple column graph. Just draw out an area right over here, let's get the Graph Data window here and let's start typing in some values. Let's say we want to actually compare, let's say the sales of apples and oranges. So, let's start with apples first. Let's say sales are going to be in millions and we'll say we'll do 12 million the first year, 18 million the second year, in the third year, maybe we had a bad year, 8 million and then we earn up to like 34 million, right. So let's say over 4 years. So, now we'll go ahead and we'll look at the oranges here. So let's say maybe the oranges are a little bit more than apples, right. So, let's say we have around 18 the first year, we have about 22 the second year, again we had a pretty bad year so let's say we only have let's say 13 and then for other year we had a really great year, about 45 million.

So, now if I click on the Apply button here to accept those values, I can see that I could very easily compare the actual amount of revenue between the apples and the oranges for each of these years. Let's say this is 2004, 2005, 2006 and 2007. But if I'm just looking at this chart right over here, I have no idea what the 0-50 represents. There is also no way for me to know that these black areas are actually supposed to be apples and these lighter gray areas are supposed to be oranges and I certainly have no idea that these are actual years here. So, let's learn how we can format data just a little bit differently to bring that information into play. I'll start here in the Data window by clicking and dragging here to select these four areas. I'll press Command+X or Ctrl +X to cut that content. I'll highlight these four regions here and I'll paste.

I'll also move these values in exact same way by putting them here and pasting them into this location. So, what I have basically done here is I freed up the first row on the top and then first row on the left here, which I can use to actually help me specify value. So, for example right over here, since these are apples, I'm going to type in apples, then I move to this field over here and I'll type in oranges. I'll hit the Tab key to accept that value. Now, along the left side over here in this column I'm simply now going to add the years. So, I'll put a number here 2004, I'll hit the down arrow, 2005 and then I'll add the remaining years as well.

I also want to give it all the decimals here. So I'm simply going to go over here to this button right over here, Cell Style and I'll have the number of decimal set to 0, just to make it a little bit easier to read these values right here. So, now let's go ahead and click on the Apply button and see what happens and right away something seems completely wrong here. As you can see these values over here, shoot from 0 all the way to 2500. Now our values are all from 12 up to 45 at the max. In fact the lowest value here is 8. If you take a look closely over here there are actually three different series of data. There is black, a light gray and then a darker gray. We can see that over here there are oranges, apples and something else.

But if we take a close look at what we are seeing here in the Data window, we actually see that Illustrator is a little bit confused. We typed in values here of 2004, 2005, 2006 and 2007, we intended for those to be actually years, what we considered specific categories for this particular chart. However because they are all numeric, Illustrator did not know that and Illustrator thought that they were regular values to be plotted into the graph. So, we need to find some way to indicate to Illustrator that these values here are actually to be used as the names of the categories and not to be plotted into the data itself.

To do that in Illustrator we'll actually use the quote marks before and after these particular values. So I'll go ahead now and I'll highlight the first one here. I'll place my cursor right before the two over here and add a regular quote mark. I'll then move my cursor to the end, click and then add a quote mark as well. Don't use the left and right arrows to move over here because that will actually move you between different fields inside of the cells over here. So, now that I have made that change, I'll come down over here where it says 2005. Again I'll put my cursor right in before and after the value and close them in quote marks.

This is actually not a very easy thing to do, basically formatting text in general inside of this particular dialog. It is not very easy to do. That's why it's much more preferred that you actually do all this inside of Excel to begin with. But in this particular case where we are learning about how to format the data we can do that very quickly and easily right here and now it basically accepted all those things and now that they are all in quote marks, Illustrator will now treat these as categories and not as values to be charted in the graph itself. So, now I'll click on the Apply button and I could very easily see now how Illustrator has taken the information I have added and turned that into something useful in the chart itself. I now see values over here from 0 all the way to 50. By the way these were automatically generated based on the values that are inside of my graph.

I can see that Illustrator created four categories basically the four years that are here, based on the fact that I have now added these inside of quotes. Illustrator also created a legend to help me understand that the black rectangles are apples, whereas the gray rectangles are oranges. So, again it's important to realize though that a lot of this formatting can be done inside of Excel. In the fact the more that you do inside of Excel, the easier it will be when you actually need to paste that or import that data, right here into Illustrator, so that you can format it and get ready to go.

There are currently no FAQs about Illustrator CS4 Beyond the Basics.

Share a link to this course
Please wait... Please wait...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.
Upgrade now


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Upgrade now

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed Illustrator CS4 Beyond the Basics.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Welcome to the redesigned course page.

We’ve moved some things around, and now you can



Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked