New Feature: Playlist Center! Pick a topic and let our playlists guide the way—like a learning mixtape.

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

SharePoint 2010 Essential Training
Illustration by

Using the Chart Web Parts


From:

SharePoint 2010 Essential Training

with Simon Allardice

Video: Using the Chart Web Parts

A new Web Part available in SharePoint 2010 is the Chart Web Part. Now, the Chart Web Part isn't limited to the Business Intelligence Center, but that might be the first place that you come across it because it's used on a couple of the sample pages. The Chart Web Part can be fueled with a variety of data, things from Excel Services, from Business Data Connections, or from your own SharePoint lists. And in fact I have a simple custom SharePoint list that I've created here called 2010 Orders, which simply breaks down some different regions, some quarters and the amount.
Expand all | Collapse all
  1. 1m 16s
    1. Welcome
      1m 16s
  2. 16m 34s
    1. What is SharePoint?
      8m 9s
    2. SharePoint roles
      2m 5s
    3. Accessing SharePoint
      4m 48s
    4. The SharePoint product line
      1m 32s
  3. 44m 55s
    1. What is a team site?
      2m 43s
    2. Navigating a team site
      9m 41s
    3. Using team site lists and libraries
      11m 38s
    4. Editing the home page
      9m 31s
    5. Adding a Web Part
      6m 19s
    6. Deleting a Web Part
      5m 3s
  4. 10m 53s
    1. What is a Document Workspace?
      4m 2s
    2. Creating a Document Workspace
      4m 3s
    3. Deleting a Document Workspace
      2m 48s
  5. 6m 3s
    1. What is a Meeting Workspace?
      2m 7s
    2. Creating a Meeting Workspace
      2m 40s
    3. Deleting a Meeting Workspace
      1m 16s
  6. 36m 3s
    1. Exploring the available lists
      5m 30s
    2. Creating a custom list
      8m 44s
    3. Creating a custom view
      6m 43s
    4. Working with libraries
      6m 18s
    5. Using versioning and Check In/Check Out
      8m 48s
  7. 45m 55s
    1. SharePoint and Word
      6m 6s
    2. SharePoint and Outlook
      7m 38s
    3. SharePoint and Excel
      3m 54s
    4. SharePoint and Access
      2m 58s
    5. SharePoint and InfoPath
      11m 42s
    6. SharePoint and PowerPoint
      3m 46s
    7. SharePoint and Visio
      6m 20s
    8. Using SharePoint Workspace
      3m 31s
  8. 32m 8s
    1. What is a site collection?
      3m 56s
    2. Creating a site collection
      6m 35s
    3. Creating a new site
      6m 29s
    4. Customizing a site
      7m 47s
    5. Creating a site template
      7m 21s
  9. 13m 53s
    1. Understanding permissions
      3m 33s
    2. Adding a user to a site
      5m 14s
    3. Deleting a user from a site
      1m 39s
    4. Creating a new security group
      3m 27s
  10. 31m 54s
    1. Using out-of-the-box workflows
      11m 1s
    2. Creating your own workflows with SharePoint Designer
      15m 20s
    3. Creating your own workflows with Visio
      5m 33s
  11. 40m 36s
    1. Using site templates
      5m 49s
    2. Using the web content management features
      10m 40s
    3. Using master pages
      3m 37s
    4. Creating an Enterprise Wiki
      7m 14s
    5. Sharing an Access database with Access Services
      7m 19s
    6. Working with rich media
      5m 57s
  12. 53m 9s
    1. Managing documents and records
      3m 0s
    2. What are content types?
      4m 22s
    3. Creating a content type
      11m 30s
    4. What are document sets?
      2m 12s
    5. Creating document sets
      7m 49s
    6. Creating a Document Center
      4m 37s
    7. Creating a Record Center
      8m 25s
    8. Defining information management policy
      11m 14s
  13. 15m 42s
    1. Using personal and social features
      7m 28s
    2. Creating a SharePoint blog
      2m 48s
    3. Personalizing SharePoint with tags and notes
      5m 26s
  14. 21m 22s
    1. Searching in SharePoint
      4m 26s
    2. Creating a Search Center
      8m 4s
    3. Customizing Search with keywords
      3m 30s
    4. Customizing Search with scopes
      5m 22s
  15. 47m 18s
    1. Using Excel Services
      10m 12s
    2. Creating a Business Intelligence Center
      3m 5s
    3. Using PerformancePoint Services
      12m 3s
    4. Using status indicators
      8m 10s
    5. Using the Chart Web Parts
      6m 33s
    6. Using Business Connectivity Services (BCS)
      7m 15s
  16. 1m 3s
    1. Goodbye
      1m 3s

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 ...
SharePoint 2010 Essential Training
6h 58m Beginner Jun 24, 2010

Viewers: in countries Watching now:

In SharePoint 2010 Essential Training, author Simon Allardice demonstrates the full feature set in SharePoint 2010 and the necessary skills to be a SharePoint site administrator. The course shows how to use SharePoint, create sites and site collections, and plan and design sites and portals. It also covers Office integration, security and permissions, and advanced features such as document management and business intelligence.

Topics include:
  • Understanding a SharePoint team site
  • Navigating lists and libraries
  • Creating Document Workspaces
  • Using versioning and check-in/check-out
  • Integrating with Office 2010 applications
  • Adding and deleting users
  • Creating workflows
  • Working with server site templates
  • Creating a wiki and a blog
  • Working with rich media
  • Managing documents and other content
  • Sharing information with charts and status indicators
Subjects:
Business Collaboration
Software:
SharePoint
Author:
Simon Allardice

Using the Chart Web Parts

A new Web Part available in SharePoint 2010 is the Chart Web Part. Now, the Chart Web Part isn't limited to the Business Intelligence Center, but that might be the first place that you come across it because it's used on a couple of the sample pages. The Chart Web Part can be fueled with a variety of data, things from Excel Services, from Business Data Connections, or from your own SharePoint lists. And in fact I have a simple custom SharePoint list that I've created here called 2010 Orders, which simply breaks down some different regions, some quarters and the amount.

And this is a perfect example of data that's just quite difficult to look at and really understand any kind of progress, any kind of structure that's happening to it. Yes, we can understand this data if we spent enough time, but having this in a chart so we can see if certain regions are on the upswing or the downswing could be very useful, and it's very easy to do with the Chart Web Part. So I'm going to go back to the homepage of the Business Intelligence site and I'm actually going to add that Web Part to this homepage. So I'll hit my Site Actions and click Edit Page and in the Main top section, I'll click the link to add a Web Part.

The Chart Web Part can be found under your Business Data section. Select that and click Add. The Demonstration Web Part is actually quite unimpressive and that's a little bit deceptive, because the Chart Web Part can get very deep and there are a lot of options to it. Of course, this has no idea where it's meant to be bringing data from. This is just dummy data right now. So I'm going to click the link that says Data and Appearance, which will break down into two options, either customizing the look and feel of the chart or connecting it to data. Well it be nice play around with customizing it, but first we better get some data into it.

So I'll connect Chart to Data. It asks where is the data coming from, another Web Part, a list in the site collection, some Business Data Catalog information which is connecting to an external database or a line of business system, or even to Excel Services? Well, Excel Services can kind of do in their own charts, so I'm going to click Connect to a List. Click Next, select the list that I'm interested in, which in this case actually is the 2010 Orders list, click Next, hI ave a quick preview of the data, and it certainly seems to be the region, the quarter and the amount, quite simple structure there, but certainly useful, and I'll click Next across here.

Here's the really important screen when you're editing this Chart Web Part. You're declaring what is the X-Field, what's the Y-Field and are we grouping by any particular piece of data here. Now, in my case, what I'm wanting to see is the progress happening by a region over a period of time and I'm measuring progress by what's the amount of orders they've taken. So the Y-Field is amount and that's correct. That's the one that I want to be numeric going up and down. The X-Field has picked region, but that's not actually what I want. I want the X-Field to be quarter, so that as we're moving along it from Q1, Q2, Q3, Q4.

Now, if I just select those two and click Finish, we're going to get some data in here but it's not all that helpful, because it's showing the quarterly amount of information without really any rhyme or reason to it. So I'm going to go back into that Data and Appearance section and it will jump me back to that particular window where I'm going to say I want to group by region. Now, you do have other fields that you can play around with. You can label things. You have Data Analysis section, where you can select from a bunch of formulas like standard deviation and Bollinger Bands.

I'm just going to leave all of that. That's not what I'm interested in right now. I'm going to click Finish. This is a bit more like it. It certainly seems to have some kind of grouping going on. We're getting, for example, a red bar in Q1, a red bar in Q2, Q3 and Q4, but it's not obvious which one's which. We need to add a little bit more than, and we can. I'm going to go back into Data and Appearance and now I'm going to go customize this chart's look and feel, where we have an amazing amount of options that we can select from. We've got Bar Charts, we've got Pie Charts, we've got Areas, we've got Lines, we've got Points/Bubble or Financial charts.

I'm actually going to pick from the Line section here. We can go from Line. We can for Spline with markers, all sorts of them, and even selecting from 3-D looks here as well. I am going to start off with a 2-D one here. I'll pick Line and click Next. I've a variety of themes that I can select from here. I'll just accept the default. It's saying right now the Chart Width is 300x300. I'm actually going to make it a little wider so we can have more of a view of how that works and click Next.

And we can even decide to show a chart title. We can call this Orders by Month, or by Quarter rather, and decide to show the legend, which should be able to give us our regions. And we can even choose the position that this information is in. I'm going to accept that default information right now and click Finish. And that's more like it. We're at least seeing some information. We're able to follow the growth, so we can see that for example, the North region seems to be steadily growing, whereas the East region seems to be on a downward slope.

You might want to play around with the lines themselves. We might go in there and experiment with a couple of other looks here, such as jumping into even the 3-D example. Trying for grins, I try Line with Perspective. Click Next and Finish. Not really all that useful here, but certainly worthwhile to check out some of the different options here. I'll go back into the 2-D line, select the different line style, click Next. I am going to play around with the transparency here to make the colors a bit more solid.

Make sure that I'm selecting a chart title and selecting the legend and click Finish. A bit more usable here, again really up to you. It's worthwhile doing a bit of experimentation to find out if this information is a usable or not. But as you can see, with a few bits of tweaking, we can actually make this very, very different. There are a lot of options when you're using the Chart Web Part. Very easy to connect to SharePoint lists. It can also be connected to Excel Web Services and to connections that you may have defined to external systems.

Find answers to the most frequently asked questions about SharePoint 2010 Essential Training.


Expand all | Collapse all
please wait ...
Q: In the "Adding a user to a site" movie, the instructor shows how to add a user to SharePoint and demonstrates by adding a user named “gini.” But gini is already set up and recognized by SharePoint. What if I have no users set yet? How can I add someone?
A: SharePoint doesn't store a separate user database; it wants to be pointed to an existing source of users, like Active Directory. If you don't have that, you need to first add your new users as local accounts on the Windows box you installed SharePoint on. Only then will you be able to give them permission on a SharePoint site.
 
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.
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.

join now 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 SharePoint 2010 Essential Training.

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

Notes cannot be added for locked videos.

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.