Yesterday i got a request for a sample sparkline workbook at my PowerPivot and Sparklines .. the easy way blog post. I have created a sample sheet that looks like this:
And shows how it works.
You can download it at my skydrive: http://cid-7f4e0559cc74581a.skydrive.live.com/self.aspx/Openbaar/Sparklines%20sample.xlsx
Excel 2010 will be a developers heaven, the MS excel team has written a blog post on how you can get to certain data in a Excel sheet published on Excel Services 2010.
The opportunities for using REST are virtually endless. To spur your imagination, here’s a sampling of some ways to use the REST API:
- Embed a chart or range in a web page, blog post, etc.
- Embed a chart as a “linked” image into a Word document, PowerPoint presentation, or Outlook mail, and have always up-to-date information.
- Build a “mash-up” that uses Excel Services for calculation, charting, and/or as a data source.
- Build a Windows 7 gadget that displays information from an Excel workbook
- …and many more ideas I am sure our customers will think up.
Phew the SharePoint 2010 product will really be “social” and really enable self service. Read the entire post at their blog.
I made a blogpost yesterday about Gemini and in it I showed an issue about Slicers in a PivotTable that kept turning up empty:
Tatyana from Microsoft apperently read about the issue and posted the resolution in a comment:
Go to “regional and language options” in control panel and change current format to English (United States). That should fix slicers issue.
And indeed it did fix the issue, great fast reply from Microsoft:
