Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Formatting data

From: Illustrator CS4 Beyond the Basics

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.

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.

Show transcript

This video is part of

Image for Illustrator CS4 Beyond the Basics
Illustrator CS4 Beyond the Basics

137 video lessons · 29277 viewers

Mordy Golding
Author

 
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 three or more objects
      2m 9s
    5. Blending anchor points
      5m 36s
    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

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

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.


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.

Join now Already a member? Log in

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 preferences from the dropdown menu.

Continue to classic layout Stay on new layout
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.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

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
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.