Sparkline chart not reflecting rounded values from pivot table

**Paul-NYS** · 10-07-2012, 12:11 PM

Hi
Below is a link to a sample workbook of my issue. I have a sparkline chart that is not reflecting the rounded values from a pivot table. If you go to the tab that says 'Tables', its the top sparkline chart. This chart is linked to the pivot table in the 'pivot' tab. This pivot tab has all rounded values of 2% for the NY item already selected, however, is you look at the sparkline chart, it shows an up and down pattern, which apparently reflects unrounded values. I want it to display a straightline value representing the rounded values.

Any ideas would be greatly appreciated?

http://www.nycourts.gov/surveys/cwci...ne-10-7-12.zip

Paul

**Andy Pope** · 10-08-2012, 04:59 AM

You need to round the value returned from GETPIVOTDATA

=ROUND(GETPIVOTDATA("Sum of 24 months",pivot!$A$7,"Metric","M1:Achievement of Permanency","DataElement","Cumulative %","Description","Adoption","year",2006),2)