I've created a stacked bar chart. One of the values I'm displaying is the distinct count of records per group, the other value is the percentage of the grand total that is represented by the distinct count. I want to change the display of the percentage from a "number" to a percentage, but when I right click the data label and select Format Data Label, and choose Percent on the number tab (with 0 decimal places), it changes from 30 to 2,956%. Now the actual percentage is 29.56%, so it seems to be calculating correctly, but misplacing the decimal.
Any help getting this to display 30% instead of 2956% would be greatly appreciated.