I have created a pivot chart off of my pivot table. I have used the same category twice (overall rating)...I want it displayed once as a straight count number and in the second row as a percentage. It appears perfectly correct in my pivot table, however, in my chart it continues to display the percentage as a decimal point number...i.e., the actual value is 0.058823529 but I have formatted the cell and the value to appear as a straight percentage...in this case should be 6%. pivotchartpercentageexample.jpg Any ideas on how I can correct this or what I am doing wrong? Thanks.