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

006 Magically building graphs with the Chartwell font

From: InDesign Secrets

Video: 006 Magically building graphs with the Chartwell font

Anne-Marie Concepcion > Do you ever wish that InDesign had a little charting function? You know something kind of like Illustrator but simpler, where you can easily whip up bar charts or a pie or something like that? So here's a workaround for that. So I'm not going to show you a hidden charting function in InDesign, though I would love to. Instead, I'm going to show you a way that you can use a typeface to create charts. The typeface is called Chartwell and it's really cool how you can use it. So let me show you. I've created a text frame in InDesign and let's say that my client has given me the statistics that they want a pie chart and they want to show 30% did X, 45% did Y, and 25% did Z. Right, that adds up to 100.

006 Magically building graphs with the Chartwell font

Anne-Marie Concepcion > Do you ever wish that InDesign had a little charting function? You know something kind of like Illustrator but simpler, where you can easily whip up bar charts or a pie or something like that? So here's a workaround for that. So I'm not going to show you a hidden charting function in InDesign, though I would love to. Instead, I'm going to show you a way that you can use a typeface to create charts. The typeface is called Chartwell and it's really cool how you can use it. So let me show you. I've created a text frame in InDesign and let's say that my client has given me the statistics that they want a pie chart and they want to show 30% did X, 45% did Y, and 25% did Z. Right, that adds up to 100.

So all you need to do is you type out those numbers, the actual numbers, no spaces, use a plus symbol in between each one, and then turn on Ligatures, which should be on by default. But I've turned them off in the meantime while I was playing around with this. So Ligatures should be on. Then as soon as you change the typeface for these numbers to Chartwell, watch what happens. So I'll come up here and choose Chartwell and I'll make sure to choose the pie.

Big deal, you know, so it's a circle. Let's undo and instead before we do that let's change the color. So Swatches. We'll make the color of 25 red and the color of 45 green and the color of 30 we'll make it this pretty orange. Let's try that again. Select these, make sure Ligatures is turned on, and change it to Chartwell, Pies. There you have it. So you can actually make this larger. It's actual characters, but it has actually made a pie chart.

Now what if the client says, you know what I got the numbers wrong. Or I need to add another section to that pie chart. Well, you just have to adjust the numbers. Now you can do that in one of two ways. Now you could select this pie chart, and then turn off Ligatures, and there are our numbers and you can edit them that way. Or because we have this wonderful thing called the Story Editor in InDesign, you can just go to the Story Editor for that story that contains the Chartwell numbers. Edit > Edit in Story Editor. Or remember you don't see formatting in Story Editor.

So here, we can say, instead of 25, we want to be 15 plus 10. And we're going to color the 10 blue. There you go. Now if you wanted to manipulate this chart, like you want to make it 3D or something like that, you going to have to convert the font to outlines and then you can take the pieces apart. They'll all come through as anchored graphics. But just in itself being able to quickly whip together a pie chart is so fun! Let me show you an example of the ways you can speed that up.

Down here in this text frame I have the numbers already set up. And they're colored because in the Paragraph Style panel, I created a paragraph style called Make a Pie. Now to show you the numbers I duplicated it and turned off Ligatures. But let me show you how it's set up. I created nested styles so that the first number gets colored 100% of the color I called pie green and that character style gets applied through the first plus symbol.

So I've created character styles for each one of these colors and then in the paragraph style called Make a Pie I used nested styles to automatically step through all those colors. So for example if I took out this one then all the other colors increment. If I say, oh that should be, let's put that back at 33. Now let's turn on Ligatures so just choose Make a Pie. This one has Ligatures turned on. And there's my pie chart. Another cool thing you can do with Chartwell Pies-- See there's three variations of Chartwell, Bars, Lines, and Pies.

We'll look at Bars and Lines in a second. If for a pie chart only, you can add a letter at the end, which will put a hole in the middle of this, turning this into a ring chart as opposed to a pie chart. If I said +a, it makes a little tiny circle. Hard to see. I'm going to color that a black. And 30. Nah, we don't want 35% of black. We want it 100% of black. So let me go back here.

Or let's actually jump to M. It makes it a little larger. Or if you said capital A, it makes it even larger, all the way capital Z. So from little A to capital Z, smaller and larger circles. Let's actually change the color here to Paper for that capital A. And now we have a little ring chart. Pretty neat, huh? And again if the client says, oh you know one of these numbers is different, then all you need to do is go to the -- you don't even need to select it. Just go to the Story Editor and change the numbers up here.

It's something I've never seen before, but it works really well. You know, this font will not work now in some programs like Microsoft Word. It can't figure out what you are supposed to do. But in InDesign, Illustrator, and Photoshop, it works great. Remember, it's always the Ligatures that turn it from the existing numbers with plus symbols into the actual chart. So here, I have some numbers written out. And I've assigned the font style Bars to a Chartwell's Bars. But Ligatures is turned off. So you can see the numbers.

I'll come over here and turn on Ligatures. And that is what the bar chart looks like. So let's undo. 50, 130, 450, 200, and Ligatures, there it is. Now if you want, I'm going to go up to Story Editor, you can put little cap on the end by ending it with the equal symbol. And then I'm going to close this equal symbol so you can see it a little better. We'll color that black as well. So, you don't have to use a stacked bar chart like I've done here. What you could do would be to create on one line say 50, the next line say 130, the next line say 450, select them all, and turn them into bars.

Like let's go ahead and do that. I'm just getting rid of the plus symbols and turning them into separate paragraphs. So then you can have a legend on the left showing the different amounts of things and then on the end of each one of these, you can add a little cap, you know you'd color it black. Actually, I should just copy and paste this one right. It's already colored black, I'll just paste it there, and there and there, and make a nice little bar chart for yourself. And just change the leading to change the spacing of the bars. Very flexible in that way. The last one that we have down here is called Chartwell Lines.

So let's take a look. This one I've already turned on Ligatures and I'll open up Story Editor. Lines should be called area chart. It's an area chart. It fills in according to the numbers. You can have as long of a string of numbers as you want and then you just add plus symbols after that. So it starts out 25, 5, 100, 45, and so on. If you want to adjust something, like let's say it's not a hundred. It's more like 95, I'll select the number 100, replace with 95, and it reduces a little bit. So though I'm not able to show you a charting function in InDesign, al you need to do is get yourself the Chartwell font and you can have all sorts of fun playing with Ligatures turned on and off to make all sorts of fun charts.

Now I've queued up to the designer's website here. It's TKType.com, and he's designed a couple typefaces. Otari's just a regular typeface. I thought it was another really neat one like this. But this Chartwell is just amazing. I mean he's got instructions here. They're $20 per font for bars, pies, and lines, or buy all three for $50. So check it out. It's a fun way to make charts with a font in InDesign.

Show transcript

This video is part of

Image for InDesign Secrets
InDesign Secrets

159 video lessons · 74323 viewers

Anne-Marie Concepción and David Blatner
Author

 
Expand all | Collapse all
  1. 3m 15s
    1. 159 Convert rounded corners to editable paths
      3m 15s
  2. 14h 28m
    1. 001 Intro to InDesign Secrets
      51s
    2. 002 The hidden "auto-expand text" feature
      5m 51s
    3. 003 Letting InDesign do the math for you
      3m 15s
    4. 004 The indispensible Quick Apply feature
      5m 29s
    5. 005 Customizing the Links panel
      6m 53s
    6. 006 Magically building graphs with the Chartwell font
      7m 43s
    7. 007 Using the Eyedropper tool to pick up character or paragraph attributes
      3m 21s
    8. 008 Selecting through and into objects using cmd-click and Select Above/Below
      5m 46s
    9. 009 Some great tips and tricks for the Swatches panel
      9m 40s
    10. 010 Saving down for backward compatibility with INX and IDML
      5m 55s
    11. 011 Using the INX and IDML formats to fix problems
      4m 46s
    12. 012 InDesign's Easter eggs
      5m 0s
    13. 013 Three cool GREP styles everyone can use
      7m 35s
    14. 014 A field guide to special characters
      8m 2s
    15. 015 Trashing the application preferences to solve weird behaviors
      4m 42s
    16. 016 Aligning numbered lists by decimal points
      3m 10s
    17. 017 Running a script
      9m 33s
    18. 018 When text disappears from a text frame
      6m 18s
    19. 019 Preview and Presentation modes (changing color, etc.)
      4m 8s
    20. 020 Using multiple windows for comparisons
      3m 35s
    21. 021 Putting images on a stroke
      5m 23s
    22. 022 Making your own motion path
      5m 43s
    23. 023 Copying objects between Illustrator and InDesign
      6m 53s
    24. 024 Using layer comps in Photoshop files to show alternates in InDesign
      4m 19s
    25. 025 Adding custom HTML tags to EPUB/HTML exports
      5m 32s
    26. 026 Tracking down type issues with the composition highlighter
      8m 13s
    27. 027 Managing your InDesign panels
      5m 46s
    28. 028 Creating running heads using variables
      5m 1s
    29. 029 Live Caption tips and tricks
      8m 3s
    30. 030 Making professional drop caps
      10m 37s
    31. 031 Making two-state buttons in interactive documents
      5m 5s
    32. 032 Moving pages from one document to another
      3m 15s
    33. 033 Wrapping bulleted text around a curve
      5m 58s
    34. 034 Importing a custom dictionary
      7m 8s
    35. 035 Changing document orientation and page size
      6m 45s
    36. 036 Numbering instead of using auto page numbers
      6m 23s
    37. 037 Setting story order with the Articles panel
      8m 3s
    38. 038 Updating a linked table without losing formatting
      5m 38s
    39. 039 Creating electronic sticky notes
      4m 49s
    40. 040 Moving master page items to the top layer for visibility
      2m 48s
    41. 041 Five guide tricks that will impress your coworkers
      6m 18s
    42. 042 Letting InDesign add the diacritics
      4m 21s
    43. 043 Using single-cell table cells for custom paragraph formatting
      6m 2s
    44. 044 Formatting fractions correctly
      8m 11s
    45. 045 Fixing unwanted hyperlinks in an imported Word file
      5m 57s
    46. 046 Inline graphic tricks with invisible paragraphs
      4m 21s
    47. 047 Ensuring the first line of every chapter starts in the same spot
      3m 1s
    48. 048 Specifying an exact amount of space between objects
      5m 17s
    49. 049 Fixing last lines that are too short
      8m 16s
    50. 050 Creating web graphics from your InDesign artwork
      7m 20s
    51. 051 Using “No Language” to suppress unwanted hyphenation, spell-checking, and smart quotes
      2m 48s
    52. 052 Five things that should be in every new file
      5m 19s
    53. 053 Forcing EPUB page breaks with invisible objects
      6m 21s
    54. 054 Understanding component information
      6m 39s
    55. 055 Creating running heads using section markers
      4m 16s
    56. 056 Making a font with InDesign using the IndyFont script
      5m 20s
    57. 057 Finding where that color is used
      7m 17s
    58. 058 Text wrapping
      6m 54s
    59. 059 Inserting pages: Understanding the Pages panel
      4m 20s
    60. 060 Copying paths between Illustrator and InDesign
      5m 14s
    61. 061 Automating Find/Change with the Find/ChangeByList script
      12m 48s
    62. 062 Embedding images
      7m 43s
    63. 063 Adjusting leading inside a paragraph
      4m 31s
    64. 064 Placing one InDesign file inside another
      3m 58s
    65. 065 Creating bookmarks for PDFs
      7m 25s
    66. 066 Customizing the story editor preferences
      6m 4s
    67. 067 Setting the size of text exactly with this free script
      3m 28s
    68. 068 Using Gravity to simulate perspective
      3m 15s
    69. 069 Fixing the overflowing text frame problem in EPUBs
      5m 0s
    70. 070 Ten uses of the Story Editor
      11m 39s
    71. 071 Moving an object: Ten ways!
      7m 18s
    72. 072 Understanding optical margin alignment (and the quote trick)
      4m 23s
    73. 073 Changing the shape of any frame with the pen tool
      6m 12s
    74. 074 Working with sets in the content conveyor tool
      10m 40s
    75. 075 Running text along the top and the bottom of a circle
      3m 51s
    76. 076 Creating a list using the Table of Contents feature
      3m 25s
    77. 077 Quickly threading frames together and unthreading frames
      13m 22s
    78. 078 The secrets of formatting objects with Find/Change
      6m 34s
    79. 079 Using ruler guides: 10 great tricks
      5m 3s
    80. 080 Converting a clipping path to a frame
      4m 24s
    81. 081 Adding a drop shadow to a single word inside a frame
      3m 14s
    82. 082 Creating a custom cross-reference format
      13m 53s
    83. 083 Putting different-sized pages on a single spread
      3m 7s
    84. 084 Formatting prices with nested and grep styles
      6m 21s
    85. 085 Checking out the Gridify tricks
      5m 17s
    86. 086 Using Illustrator to create InDesign gradient swatches
      4m 49s
    87. 087 Building a simple grep style to change character size
      3m 45s
    88. 088 Exporting a grayscale PDF
      3m 16s
    89. 089 Three ways to cheat text outside of its frame
      6m 8s
    90. 090 Three great Object Styles for any designer
      8m 1s
    91. 091 Choosing alpha channel image transparency
      2m 25s
    92. 092 Adding and reading metadata for InDesign files
      3m 25s
    93. 093 Adding ALT tags to your images
      6m 59s
    94. 094 How to Place & Link a text frame's text but not its formatting
      7m 4s
    95. 095 Setting the baseline position of a caption
      2m 39s
    96. 096 Managing changing pages with primary text frames
      5m 23s
    97. 097 Secrets of the Info panel
      7m 31s
    98. 098 Surprising ways to do a word count
      5m 29s
    99. 099 Placing an object where you want it with an object style
      6m 18s
    100. 100 Aligning Objects tips and tricks
      5m 10s
    101. 101 Applying corner options to any shape
      2m 17s
    102. 102 Converting footnotes to endnotes with a free script
      4m 49s
    103. 103 Making tab leaders pretty
      4m 18s
    104. 104 Converting text to outlines the right way
      4m 30s
    105. 105 Turning InDesign into a speed demon
      8m 31s
    106. 106 Working with MiniBridge
      5m 45s
    107. 107 Customize your QR codes
      6m 17s
    108. 108 Using the same keyboard shortcut for two different commands with the Context feature
      5m 22s
    109. 109 Making a text highlighter
      3m 33s
    110. 110 Updating an interactive PDF without losing work done in Acrobat
      5m 31s
    111. 111 Adding custom text at the beginning of each line automatically
      4m 0s
    112. 112 Packaging images on the pasteboard
      3m 32s
    113. 113 Automatically updating figure references for books
      6m 9s
    114. 114 Adding Tool Tips to your form fields in InDesign
      3m 21s
    115. 115 Setting poetry, flush left, center on longest line
      3m 54s
    116. 116 Use bookmarks to navigate long documents in production
      4m 57s
    117. 117 Selecting text with the InDesign keyboard dance
      2m 0s
    118. 118 Including a total page count in your page numbers
      6m 19s
    119. 119 Making a custom arrowhead
      5m 37s
    120. 120 Making alternative body text styles for fast typesetting
      5m 4s
    121. 121 Making InDesign patterns with the free PatternMaker
      3m 45s
    122. 122 Creating pull quotes the easy way
      5m 1s
    123. 123 Allow text frame to resize with text
      2m 43s
    124. 124 Mapping Word styles to InDesign styles
      5m 48s
    125. 125 Make two automatically threaded text flows
      3m 37s
    126. 126 Saving for Web in InDesign
      6m 7s
    127. 127 Numbering rows in a table
      5m 10s
    128. 128 Making automatic jump lines
      6m 52s
    129. 129 Turning off allow pages to shuffle in order to separate facing pages
      3m 40s
    130. 130 Dealing with parentheses around text size
      4m 19s
    131. 131 Make a fill in the blank label for contracts and forms
      7m 53s
    132. 132 Changing the shape of polygons and starburst as you draw or afterward
      4m 17s
    133. 133 Contextual text and images that you only want sometimes visible
      4m 55s
    134. 134 Creating nav points in a movie
      4m 31s
    135. 135 Adding effects to your rule above and rule below
      3m 38s
    136. 136 Fitting text to a specific size
      4m 45s
    137. 137 Quick tips for making a small PDF file size
      6m 9s
    138. 138 Sharing presets, workspaces, and custom shortcuts sets
      5m 17s
    139. 139 Making a multi-level numbered list
      5m 17s
    140. 140 Faking bold and italic when the font family doesn’t have one
      5m 2s
    141. 141 Keeping the same scale size when updating or relinking to images
      3m 9s
    142. 142 Inserting glyphs
      6m 42s
    143. 143 Building richer, bolder color gradients
      3m 7s
    144. 144 Finding the right font with InDesign’s font menus
      4m 35s
    145. 145 Lay out a front, back and spine for a book jacket
      6m 12s
    146. 146 Ghosting area of image behind text
      2m 53s
    147. 147 Make a transparency mask in InDesign
      3m 45s
    148. 148 Using preflight to find common document errors
      6m 11s
    149. 149 Cropping with paste into
      5m 18s
    150. 150 Using vertical justification to spread out text in a frame automatically
      5m 16s
    151. 151 Rotate text inside a frame, or the frame around the text
      2m 30s
    152. 152 Looking at snippets vs. libraries
      6m 49s
    153. 153 Import a folder full of pictures, one per page
      8m 54s
    154. 154 When InDesign ignores your leading values
      4m 5s
    155. 155 Extracting images from a Word document
      3m 42s
    156. 156 Uncommon uses for Quick Apply
      6m 2s
    157. 157 Uncovering InDesign's magic font folders
      3m 9s
    158. 158 Sharing swatches (PS/IL/ID and ID to ID)
      3m 36s

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.

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 InDesign Secrets.

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
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.