bar on chart isn't representing correctly

[rrupp]

I have a bar chart pulling from data in a sheet. My data is percents, for
example, showing Physican data. My bar chart has one physician that is at
85% but the bar doesn't go to the 85% line. It falls just short of it. I
have double-checked the data and when I look at the data labels, it
represents that bar as "Physician A 85%". The other bars go to the correct
line level but not this one. It is set up exactly the same. I'm stumped,
any ideas?
Office 2003

 

[Del Cotter]

I have a bar chart pulling from data in a sheet. My data is percents, for
example, showing Physican data. My bar chart has one physician that is at
85% but the bar doesn't go to the 85% line. It falls just short of it. I
have double-checked the data and when I look at the data labels, it
represents that bar as "Physician A 85%". The other bars go to the correct
line level but not this one. It is set up exactly the same. I'm stumped,
any ideas?

Is "85%" an integer, or a calculation displayed as a number rounded to
the nearest integer? It may really be 84.5%, instead of 85.0%, and
you're noticing that 0.5% on the graph.

To fix the calculation, make it actually be an integer, using INT() or
ROUND() or one of the other truncating functions.

 

[David Biddulph]

If the numbers are really percentages, 85% isn't an integer, but 0.85. INT
would lose you the lot. ROUND would need to be to 2 decimal places, not to
zero places.