Sams Teach Yourself Microsoft® SharePoint™ 2003 in 10 Minutes

Using Excel for Charting

Using Excel for charting is very similar to using Excel for printing. Instead of clicking Print with Excel from the task pane in Datasheet view in a library or list, simply click Chart with Excel. When the new spreadsheet is created, the Chart Wizard will open to assist you with creating the graph. Typically you won't be able to print the graph you want without some sorting, and it is easier to select the columns to graph before you open the wizard.

For instance, to create a meaningful graph from the example shown in Figure 14.1 of the tasks exported from the tasks list, follow these steps:

1.	View the list in Datasheet view and click the Task Pane button in the toolbar above the content of the list, or you can click ...