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