I need to evaluate a possibility of displaying a chart on SharePoint site using data from a list.

List has columns: status, month and some more, but a chart that we need to show on SharePoint site should aggregate data in a list and display something like this:

Status      Jan             Feb   March ....

Initial          10(items)    5      12

Processed    3(items)    23     25

I am new to SharePoint and will appreciate any information on this topic or point to a source of information. thx

Are you using MOSS (Office SharePoint Server) 2007 Enterprise (with Excel Services)?

If so, just create "the perfect worksheet" in Excel, save it to a document library, then users can view it either in Excel (locally on the client from the library) or using "View with Web Browser" in which case Excel Services will render it.

So SharePoint (WSS or MOSS) is just "storing" the perfect Excel worksheet that does the work.  IF you have MOSS/Excel Services, it can render that sheet to a web browser.

---

Dan Holme
Office & SharePoint Pro Community Leader
MVP (Windows Server - Directory Services)

Thank you, Dan,

But does it mean that worksheet will have "stale" data and will need to be refreshed periodicatlly? I need data to be refreshed on SharePoint site every time when new item is added to the list.

Could you recomend some reading on this topic? I am using WSS 3.0.

Take a look at this customized page where a chart gets data from a Sharepoint list.

 

 

http://www.sharepointmall.com/Demos/Projects