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

Using the Charts module and Google Charts

From: Drupal 6: Online Presentation of Data

Video: Using the Charts module and Google Charts

We have already see one kind of graphical presentation of data in the video mapping with the Gmap Module. But what about when you want to present non-locational data? For that you need a chart and fortunately Drupal has a Module set up exactly for that. It's called un-surprisingly the Charts Module. By itself it doesn't actually charts, rather it works together with Views to prepare and deliver data in your Drupal site so that other services can then into graphical chart form. As I say this, this Module includes hooks to 3 sets of services, Google Charts, which simply turns your data into a graphic which gets send back to your site. Open Flash Chart, which is a Flash-based solution with some really neat features. And Fusion Charts, a commercial solution.

Using the Charts module and Google Charts

We have already see one kind of graphical presentation of data in the video mapping with the Gmap Module. But what about when you want to present non-locational data? For that you need a chart and fortunately Drupal has a Module set up exactly for that. It's called un-surprisingly the Charts Module. By itself it doesn't actually charts, rather it works together with Views to prepare and deliver data in your Drupal site so that other services can then into graphical chart form. As I say this, this Module includes hooks to 3 sets of services, Google Charts, which simply turns your data into a graphic which gets send back to your site. Open Flash Chart, which is a Flash-based solution with some really neat features. And Fusion Charts, a commercial solution.

We are only going to look at the first two of these. That is, Google Charts and Open Flash Chart. Our task is to get a visual representation of which states are home to the most family members. As I have done a few times in this course, I have to warn you about the quality of the Modules involved, they work but as I'm recording this video in March 2009, they are still very immature and very, very tricky. I'll walk you through them of course and hope that it all improves by the time that this video is released. The unpredictable world of software development, particularly volunteer software development.

Our first step is to enable some Modules. We go to Administer, Site building, and Modules. Once there, scroll down until you come to the Chart section, we are going to enable only two, Charts and Google. I should warn you again, at the moment that I'm recording this, this Module is so immature that if you turn on some of these other Modules without having other certain pieces installed, it could actually crash your site. So Charts and Google, at least you know that you will be safe. Scrolling down, we click Save configuration. We'll come back to the Modules later and I'll explain how you can turn them on safely. After you have turned on the Modules, you might naturally then head over to the Views administrative interface and start setting up your view.

Unfortunately, again the Charts Module is somewhat immature and fails to warn you that you first need to configure the Module itself, if it was working correctly it would normally tell you here but instead you only find out if you happen to go the Administer page and then you see this error that you need to something. We click on the status report to see what. Now it tells us we have to go to the settings page to set up Charts. If we had enabled more than just the Google Chart plug-in, that is the Open Flash Chart, or the other one, we would see that in this pop-down menu here. But if it's just Google, that's fine.

We can change the width and height of the Chart and as we scroll down we can change the color of the Chart. But again it's not working quite the way you expect. Normally, you would click in here and then click over here on the color wheel to change the color, but it doesn't actually work yet. So, we'll just change it manually. If you would like to find out what colors you are actually using, you could use a separate program such as Photoshop and look at a Hex Chart. We'll just change this to 00033, just so we can see a different color, and save settings. After you have saved this once, you then have a choice of what Chart type to use, by default its set to Horizontal Bar 2D. We are actually going to be aggregating the information of how many people live in each state and a Pie Chart is more appropriate for that.

Graphing data is a complex field and there are a lot of potential gotchas one of them is choosing the wrong Chart type. Make sure that you check you data when you are done and look at the graph to compare and make sure that you have chosen one that actually makes sense. We will take Pie 2D, and scroll down and save settings. Good. Now we are actually ready to go and build our View. One nice thing about the Module I'll say is that it gives you little preview so you can get a sense of what the Chart will look like with your data. But we'll go on to our View. I go to Administer, Site building, and Views. Once there, I add a view. I'm going to call this chart_of_households. I'll call the description, Chart of households.

As usual, we won't add a tag and it's going to be a view of Nodes. Scroll down and click Next. Here, I'll do my usual default things that I do with Views. I'll set up my Filters, so it only shows published nodes of the type household. Scroll down, choose the Node group, scroll down again, Published and Type. Click Add, Yes Published and type is Household, and Update. I am also going to make sure that we see everything that we want, all of the nodes, so I change the Items to display from 10 to 0. And you could imagine, if you have many states in there, all 50 states with people living in them, then you would only get the first ten that would lead to some very strange results.

We click on Update, and finally, add some Fields. The criterion we are looking for, remember is states. As it happens, the Location Module calls them Provinces to be a little more international. We find it by choosing the Group Location and scrolling down to Province. Accept that choice, click Add and then make our usual changes. I am going to take away the Label, for example, and look at all the other ones. One of the interesting ones here is you can choose between the Province name, that is, California for example, or the Province code. In this case it would just be CA. I'll leave it on the name and click Update. There, we now have a list of all of our households and as you can see three are in California and one each are in three other states. But we want to see this as a Chart. As it happens, that's the easy part of the equation.

We simply scroll up, go to our Style and change it from Unformatted to Chart. Scroll down, click Update and set our options. Let's scroll up to see all of those options. We are asked once again what our format should be, and again, be sure that you compare your data to the finished chart to make sure you chose the right one. We can change the height, the width, the Background color, we are going to leave all of those alone for right now. But I do want to discuss this Conversion type. Let's leave it as it is, Display numbers from every row, and click Update. We actually get an error because of the type of data that we are using. We don't actually want to show the number California. It's not a number. And so of course, we get this warning. Ideally, we would get a friendly warning than this big red box with lots of code in it, but that's the way the Charts Module works.

Instead, we want to go up and edit our Style, scroll down again and change it so it, Displays a some of different values. There are four different values here, Ohio, New York, California, and Illinois, and that's going to be submitted. I'll click on it, and click Update. Now we see our Chart and it actually looks pretty much like we expected it to. There are six households, three of them in California, so we see it as half of the Chart. I'll click Save to be sure we keep that. The Google Chart API really is the fastest way to get Charts on your site, but it is somewhat limited. I'm hopeful that the Charts Module will continue to mature to support more and more of the Google Chart API leading to increased possibilities for Charts on your Drupal site.

Show transcript

This video is part of

Image for Drupal 6: Online Presentation of Data
Drupal 6: Online Presentation of Data

50 video lessons · 11361 viewers

Tom Geller
Author

 
Expand all | Collapse all
  1. 12m 56s
    1. Welcome
      1m 12s
    2. Reviewing requirements
      3m 35s
    3. Using the exercise files
      3m 11s
    4. Touring examples of data visualization
      4m 58s
  2. 27m 56s
    1. Planning data structure
      8m 26s
    2. Importing and manipulating data
      6m 40s
    3. Looking at Drupal's database
      6m 13s
    4. Deciding whether to store personal data as nodes or users
      6m 37s
  3. 1h 13m
    1. Understanding the Content Construction Kit (CCK)
      4m 57s
    2. Creating new content types with CCK
      7m 26s
    3. Hiding the Body field
      2m 46s
    4. Reflecting CCK field data in the Title field
      7m 28s
    5. Managing CCK field placement
      7m 34s
    6. Exploring CCK's other features
      8m 22s
    7. Using other CCK field types
      3m 25s
    8. Adding date information as a CCK field
      8m 43s
    9. Including images as CCK fields
      10m 23s
    10. Connecting content to existing nodes
      5m 58s
    11. Using taxonomies to categorize and group data
      5m 59s
  4. 53m 54s
    1. Understanding why views are useful
      6m 12s
    2. Using SimpleViews to create basic content views
      5m 49s
    3. Diving into the Views interface
      11m 16s
    4. Adding fields to a view
      7m 12s
    5. Understanding iconic controls in the Views interface
      7m 15s
    6. Surveying the Sort, Filter, and Field options in Views
      5m 40s
    7. Adding view displays as pages, blocks, and RSS feeds
      10m 30s
  5. 43m 34s
    1. Overriding default settings on view displays
      8m 56s
    2. Attaching more information to views
      10m 57s
    3. Improving view appearances with grid, list, and table formatting
      9m 20s
    4. Surveying other basic display settings in Views
      11m 3s
    5. Altering a view's appearance through CSS
      3m 18s
  6. 55m 8s
    1. Importing, exporting, and cloning views
      6m 9s
    2. Controlling access to views
      7m 19s
    3. Learning from built-in views
      5m 52s
    4. Creating views that aren't based on nodes
      10m 6s
    5. Extending views with arguments
      10m 17s
    6. Extending views with relationships
      7m 2s
    7. Going further with relationships
      8m 23s
  7. 46m 40s
    1. Understanding geographic data
      4m 26s
    2. Setting up the Location module
      16m 20s
    3. Entering geographic data with the Location module
      10m 10s
    4. Displaying basic maps with the GMap module
      6m 43s
    5. Integrating the GMap module with Views
      9m 1s
  8. 54m 21s
    1. Exporting data in tabular form
      11m 25s
    2. Planning with the calendar modules
      11m 31s
    3. Using the Charts module and Google Charts
      7m 11s
    4. Graphing data with Open Flash Chart
      4m 50s
    5. Making important data pop out with tag clouds
      7m 46s
    6. Putting it all together in an attractive package
      11m 38s
  9. 36s
    1. Conclusion
      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.

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 Drupal 6: Online Presentation of Data.

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.

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.