Ever wanted to display a list status results in a pie chart withou using Excel? Read below and see how simple it is. If you have any questions, please email me.

• Create a list (task list or custom list)
• Create a document library and title it jquery
• Download the jquery.js file from the JQuery site – click HERE
• Upload the file to your jquery folder - Rename the file to jquery.js (remove the version)
• Create a new web part page
• Add the list you created and then group it by a column (the pie chart will only work with grouped views)
• Add a Content Editor Web Part to the page
• Click Source Editor and past the following code (the code has taken from EndUserSharePoint.com site:

• <div id="jLoadMe" class="content"><strong>Pie Chart Using Google Charting API</strong></div>

  <script type="text/javascript">

  if(typeof jQuery=="undefined"){

              var jQPath="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/";

              document.write("<script src='",jQPath,"jquery.js' type='text/javascript'><\/script>");

  }

  </script>

   

  <script

  type="text/javascript">

  $("document").ready(function(){

              var arrayList=$("td.ms-gb:contains(':')");

              var coord= new Array();

              var labels= new Array();

              $.each(arrayList, function(i,e)

              {

                                   var MyIf= $(e).text();

                                   var txt= MyIf.substring(MyIf.indexOf('(')+1,MyIf.length-1); // Extract the 'Y' coordinates

                                   coord[i]=txt;

                                   var txt1= MyIf.substring(MyIf.indexOf(':')+2,MyIf.indexOf("(")-1); // Extract the labels

                                   labels[i]=txt1+"("+txt+")";   //add also coordinates for better read

              });

              var txt= coord.join(",");

              var txt1= labels.join("|");

              // Adjust Chart Properties below - See Google Charts API for reference

              var vinc= "<IMG src='http://chart.apis.google.com/chart?cht=p3&chs=750x200&chd=t:"+txt+"&chl="+txt1+"'/>";

              $("#jLoadMe").append("<p>"+vinc+"</p>")

  });

   

  </script>

• Look for var jQPath="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/"; line. Replace the link to where your jquery file is located. Ex http://mysite.com/jquery/
• You’re done

There isn't an out-of-the-box functionality that allows you to create custom views for surveys. But there's a work around. Try the steps below to create your custom survey views.

• Open the PowerPoint Presentation that you want to change the text color
• Click on the Design tab
• To the right of the Themes section - click on Colors
• Click Create New Theme Colors
• Select the colors for each section to include hyperlink and followed hyperlink section
• Name your new theme
• Click Save
• Your new font colors are now applied.

This one goes out to you help desk or administrators that would typically use the Active Directory administrative console to add/remove users and computer accounts, reset passwords, or any other administrative function that is performed via Active Directory.

There've been times where I've created list and wanted to add the ID number to the display form. I never really found away until now. I read a blog from PathtoSharePoint.com that explained it a little bit.

The steps below are much clear and easier to understand. Hope this helps.

• Go to the list that contains your items.
• Click on the item - now you should be in the display form
• Go the url - the url should looks something like: http://domain/sites/test/Lists/New%Test%20Form/DispForm.aspx?ID=267.....
  • Highlight - from http to aspx and delete the rest. Your URL should now look like this
  • http://domain/sites/test/ Lists/New%Test%20Form/DispForm.aspx
• Now add ?ToolPaneView=2 to the URL to take you to the edit mode. Your URL should now look like this" http://domain/sites/test/ Lists/New%Test%20Form/DispForm.aspx?ToolPaneView=2
• Click Go
• You should now be in the edit mode for the display form
• Click on Add a Web Part
• Under Miscellaneous - check Content Editor Web Part
• Click Add
• In the Content Editor Web Part
  • Click Open the tool pane
  • The add the following scripts - I've copied from Path to SharePoint article
• To view the ID in the first row - copy the code below:
  Read more... Comments (89)

There’ve been times were I’ve created custom lists in SharePoint 2007 and found the title item to be a bit of a nuisance. I didn’t know how to hide the title field since it was a default until now.