SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can i show trends (Arrows depicting relative performance) along with KPI's in Sharepoint . The KPI's have excel spreadsheet as their Datasource.

share|improve this question

I'd just create charts in the Excel files, give the charts a named range and publish it to SharePoint with Excel Services. Then you can use a Excel Services web part to display the chart.

Another option if you're using Office 2010 is to use sparklines. You could then do something similar like creating a pivot chart/table that shows the item and the sparkline.

You can't do any trending to my knowledge with the SharePoint KPI tools. Christophe has done a lot with jQuery and visualizations to do things similar for users who don't have the Enterprise SKU. You might want to review his blog, lots of good stuff there.

share|improve this answer
Hi PirateEEric, thats exactly what ive done , ive actually created pivot tables and charts (using office 2007) to allow filtering under excel services. Okay so im gonna take your word for it and say trends cant be created using only oob. – Aabid Ali Sep 28 '11 at 13:36

Your Answer


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.