Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Building Charts based on Sharepoint 2007 Lists

  Asked By: Nilay    Date: Sep 20    Category: Sharepoint    Views: 10203

I am looking for a way to graph columns in a Sharepoint list. I have
seen some posts on office 2003 web components but I think these have
been discontinued with Office 2007 so I was wondering if anyone had any
ideas what the best way would be to go about it.



8 Answers Found

Answer #1    Answered By: Gaurav Nemane     Answered On: Sep 20

Might be pricy, but Dundas has a product for graphing in SharePoint.
see www.dundas.com and www.corgent.com

Answer #2    Answered By: Marjorie Humphrey     Answered On: Sep 20

I was hoping I wouldn't have to buy anything. Is there anyway of
of using Excel with the new Excel services in 2007?

Answer #3    Answered By: Chelsey Watts     Answered On: Sep 20

You'd actually be saving money if you went the Dundas route since I'm pretty
sure it's on a per server license basis where as Excel services cost
structure is per user for the Enterprise CAL...

Answer #4    Answered By: Nagesh Maulik     Answered On: Sep 20

Are you trying to display a graph of the list in SharePoint, or in
Excel? If in Excel, you can just use the Export list to Excel
command, then build a chart from that. This will make a data
connection so that changes to the list are reflected in the Excel

If you then store the Excel spreadsheet in a trusted file location in
SharePoint, and you have Excel Calc Services/Web Access, you can
display the chart in SharePoint. Be prepared to wrestle with making
sure your chart doesn't have any features that are incompatible with
Excel Web Access.

Answer #5    Answered By: Irving Hurley     Answered On: Sep 20

Has anyone working on MOSS 2007 had any success building  a Custom Web
Part Page Template? I have a requirement to build out over 100 web part
page sites that will basically use the same web part page layout (and
preset web parts).

Any assistance and direction is greatly appreciated.

Answer #6    Answered By: Asia Meyers     Answered On: Sep 20

creating custom layout pages in sharepoint  is pretty straight and simple.

There are ways to create a layout page, I follow below method

Just open, your sps site in sharepoint designer, and try to open your defualt
page (default.aspx) then, it will ask for, your want edit its layout page say,
want to edit layout page.

Normally, layout pages will be residing along with master page. and make a
copy of any exising layout page and do chnages as per your requirement.

Answer #7    Answered By: Shelley Reese     Answered On: Sep 20

You will want a Module Feature. Modules do one of two things:
1. Copy files (often ASPX pages) to a virtual location anywhere in your
site. These files can be physically copied into the SharePoint database
(Unghosted) or they can be linked to the parent file in the 12 Hive
(Ghostable). I typically prefer Ghostable because subsequent changes to
the file on the file system are reflected in the virtual page in every
site that uses it.
2. Copy documents (like Master Pages, Page Layouts, Web Parts, or
images) to a Document Library in your site. Once again, these files can
be physically copied into the SharePoint database (Unghosted) but
typically they are linked to the parent file in the 12 Hive
(GhostableInLibrary). When GhostableInLibrary is specified, the virtual
document appears as if it physically exists in the Document Library.
This is a beautiful thing.

The File element of a Module allows you to specify the Web Parts that a
page will contain. A List View Web Part (LVWP) and/or Custom Web Part
(AllUsersWebPart) can be assigned to a specific WebPartZone and the
WebPartOrder can be specified. It is even possible (although way under
documented) to connect Web Parts when the page is first created.

The following example adds a virtual Todd.aspx to the root of the site.
Todd.aspx will have a LVWP to the Links list in the first position in
the Right Zone. So, a Links list must exist at the URL specified in the
List attribute or this entire Module will fail. Also, two Barracuda
DeliverPoint Web Parts will be placed into the Left Zone and connected

<Module Name="Default" Url="" Path="">
<File Url="Todd.aspx" Type="Ghostable">
BaseViewID="0" WebPartZoneID="Right" WebPartOrder="1" />
<AllUsersWebPart WebPartZoneID="Left" WebPartOrder="1">
<WebPart xmlns="http://schemas.microsoft.com/WebPart/v2" target="_blank" rel="nofollow">http://schemas.microsoft.com/WebPart/v2" >
<Title>DeliverPoint Treeview</Title>
<Description>Displays data from the interrogation
database in either a farm-centric or user-centric view.</Description>


<AllUsersWebPart WebPartZoneID="Left" WebPartOrder="2">
<WebPart xmlns="http://schemas.microsoft.com/WebPart/v2" target="_blank" rel="nofollow">http://schemas.microsoft.com/WebPart/v2" >
<Title>DeliverPoint Wizard</Title>
<Description>Displays the appropriate wizard for the
action requested by the DeliverPoint Treeview.</Description>




This second Module shows how to place a virtual copy of Todd.master into
the Master Page gallery:
<Module Name="ToddMasterPage" List="116" Url="_catalogs/masterpage"
<File Url="Todd.master" Type="GhostableInLibrary"
IgnoreIfAlreadyExists="TRUE" />

Modules can either be placed into a Feature or within a custom Site

Answer #8    Answered By: Vinay Thakur     Answered On: Sep 20

I guess your company is pretty well off to be able to afford the cost
of the Enterprise CAL...

Didn't find what you were looking for? Find more on Building Charts based on Sharepoint 2007 Lists Or get search suggestion and latest updates.