| Creating Sparklines in PowerPivot |
| Written by Patrick LeBlanc |
| Monday, 10 May 2010 01:39 |
|
Sparklines are new to Microsoft Excel 2010 and Reporting Services 2008 R2. In this post I will outline the steps required to create sparklines in an existing PowerPivot workbook. Sparklines provide you with the ability to create a trending graph inline with your data. So how do create these Sparklines. Let’s assume that you already have a PowerPivot workbook that contains data. In this example I will be using the AdventureWorks2008 database. I have imported the following tables: DimDate, DimSalesTerritory and FactInternetSales. I am also assuming that you have already created a Pivot Table that resembles the following:
|
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
