How do you create Stacked Charts from Lists?

Feb 4, 2010 at 3:41 PM

How do you create multi series charts (stacked charts) from data in a list on SharePoint?  Your examples show stacked charts, but not how to create them.  Is XML the only way, because then it is static and not dynamically pulled from the list?

Coordinator
Feb 5, 2010 at 6:18 PM

In order to graph multi series charts, you will have to use the web part "Chart From XML".

You can make this XML directly pulled from the list by creating an application page :

1 - Create an application page on SharePoint
http://msdn.microsoft.com/en-us/library/bb418732.aspx

2 - In the code behind of the page (or inline code if you don't use code behind) simply open your SharePoint List (SPList) and loop through all items in the list to dynamically build your XML according to the XML Reference of Fusion Charts.

3 - Output your XML by using Response.Write(myXML);

Laurent.

 

Feb 6, 2010 at 12:36 AM
Wonderful. Do you by chance have a simple code example that you did for #2 and 3?

James Dyas

Senior Manager
Customer Relationships
Mobile: +1 (908) 601-2429

On Feb 5, 2010, at 1:16 PM, "laurentbel" <notifications@codeplex.com> wrote:

From: laurentbel

In order to graph multi series charts, you will have to use the web part "Chart From XML".

You can make this XML directly pulled from the list by creating an application page :

1 - Create an application page on SharePoint
http://msdn.microsoft.com/en-us/library/bb418732.aspx

2 - In the code behind of the page (or inline code if you don't use code behind) simply open your SharePoint List (SPList) and loop through all items in the list to dynamically build your XML according to the XML Reference of Fusion Charts.

3 - Output your XML by using Response.Write(myXML);

Laurent.

Feb 11, 2010 at 7:19 PM

I would also like to see some example code for this.  Thanks!

- schneid