Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 0 down vote favorite

I have an excel report with SparkLines in it. When I view the file through excel services (aka in the browser), all looks fine and dandy. But when I try to browse the file via REST services, the charts\ranges dont show SparkLines.

Are SparkLines supported via REST services? Is there any way I can show SparkLine charting data in a Business Intelligence site?

Thanks!

share|improve this question

1 Answer

up vote 0 down vote

You will need to use the excel chart web part. Here is an article explaining various methods of obtaining chart data and displaying chart data in a BI site. I believe you can access the data if you use the excel chart web part since it stores the data as a list. Take a look below

http://www.dotnetcurry.com/ShowArticle.aspx?ID=816

share|improve this answer
Thanks for the help Joseph, unfortunately this isn't exactly what I was hoping for. If I view the whole worksheet through SharePoint, the sparkline charts show in the appropriate cell. But when I browse the file via ranges, none of the sparklines appear. I was hoping to just use the exising spartlines because of the formatting our analysis team had already customized on the excel report.. – ewitkows Oct 11 '12 at 12:46
There is a way to do it as you said. Try this article it is for SharePoint 2007 but you should be able to adapt to 2010. I know what you are trying to do is possible try this link. it will use excel services to pull the chart only. codeproject.com/Articles/22239/… – Joseph D Surgeon Oct 11 '12 at 13:17
Thanks Joseph, that's close to what we need to do, but it doesn't work the same way. Sparklines aren't like other charts, you can't "name" them like you can other charts. As such, you can't make them a publishable item.. – ewitkows Oct 11 '12 at 14:49
I really can't think of another way other than making the data available and re developing an ASP.NET sparkline solution. I hope you can get what you need. I am still trying to find a solution I will post when I can find one. – Joseph D Surgeon Oct 11 '12 at 14:51
Thanks Joseph, I really do appreciate the help! I did find something close here: sharepintblog.com/2011/10/02/… - but thats ridding of sparklines and using Googles charting API's. Not that this wouldnt work, but trying to refrain from breaking "too much" of existing functionality.. unless I have to, of course. – ewitkows Oct 11 '12 at 15:23
show 3 more comments

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.