Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I want to create a chart with the built in Chart WebPart in SP 2010 from a comma separated values string in one column of a forms library.

It is a form library with promoted fields of an InfoPath form. There is a rule that gathers values from a repeated section and writes it to another field, seperated by comma. That field is promoted to a FormsLibrary column.

There should be one chart beneath the XsltListViewWebPart of the Forms library. The chart should update just when the user clicks on one of the Form items.

I managed to add a Chart Webpart to the page and connect it to the forms lib, but it wants to get its data from several list items, not just only from the current one.

Is it possible without programming to tell the Chart WebPart to split a comma seperated string from one list item field? Maybe I need to add a hidden webpart which splits the comma seperated string into values?

The Chart should look like this (or similar)

Chart dummy

The field content looks like this: "1,6,8,3,4,9,2,4,1,2,5,8,7,9,2,4,8"

share|improve this question
    
Could you explain your scenario in more detail? What do you mean by “comma separated values list in one column of a forms library” and how should the chart be updated? –  Betty Carlton Mar 8 '13 at 12:29
    
Yes, I rewrote the question, hope it gets clearer –  elsni Mar 8 '13 at 14:25

2 Answers 2

up vote 4 down vote accepted
+50

What about using Excel REST? You can create the chart you want to see in Excel then call it using REST passing through the values as parameters. Make sure you name the chart in Excel and I would also recommend you name the cells for the values using short names.

Getting an image on the page using a REST call will be something like:

<img src="http//ServerName/_vti_bin/ExcelRest.aspx/LibraryName/WorkbookName.xlsx/model/Charts('ChartName')?Ranges('V1')=1&Ranges('V2')=6&Ranges('V3')=8& . . . etc" />
share|improve this answer
    
Never heard of that, I have to check this. It is in fact interesting as the dummy chart I provided was made with excel. If it is possible to magically render an excel chart to an image on the fly, that would be cool! –  elsni Mar 13 '13 at 14:48
    
Thanks, this works, hooray! –  elsni Mar 13 '13 at 17:48

If your talking about a .csv file than it is possible as its a common format that is used in excel.

For those who dont know what csv is, its just a simple method of storing values seperated by a comma. Its readable by excel and is put into respective cells. CSV is also a good method for charting.

First step is to get the values into a .csv file. Save that file to a document library. goto the document library and right click the file and copy its url location (copy shortcut).

you can try this:

As you noted that you would need to connect either by webpart that sends the data or you can try csv file that is stored in a document library (i dont know if it will like scv but it does work for xcsl format)

Connect to another Web Part

Use this option to connect the Chart Web Part to another Web Part that is capable of sending data. Examples of such Web Parts include a Document Library or a Contacts list.

Note Make sure that the Web Part that you want to use is already on the same page as the Chart Web Part

http://office.microsoft.com/en-gb/sharepoint-server-help/create-a-chart-by-using-the-chart-web-part-HA101889211.aspx#_Toc276035255

or

Goto the page where you want to show the chart. Add Collabion Charts for SharePoint:

Collabion Charts for SharePoint lets you create charts from data stored in SharePoint® Lists, Views, CSV string or files, MS SQL, Oracle, Excel and BDC

http://www.fusioncharts.com/products/ccsp/

Click on the wizard, follow the wizard. Format (data provider) needs to be csv, check from web just below. Past in the url. Hit connect. Select what feilds you need and click apply and then on the right click chart type to select your chart and follow the wizard from there :)

vid tutorial here:

http://www.youtube.com/watch?v=d34saR_Gsk8

documentation:

http://docs.collabion.com/charts/1.1/

for excel way

http://www.codeproject.com/Articles/22239/Displaying-Charts-in-SharePoint-using-Excel-Servic

share|improve this answer
    
There is no csv file, there is a text column in a list which contains a csv string. I'll check out fusion charts and the customer's willingness to pay for 3rd party components. Thanks! If fusion charts meet the requirements then you get the points. –  elsni Mar 8 '13 at 14:31
    
Fusion Charts can't do this. I asked the support. –  elsni Mar 13 '13 at 14:49

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.