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

On Mon, 4 Feb 2008, in microsoft.public.excel.charting,
rrupp said:

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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

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.
--
David Biddulph

"Del Cotter" wrote in message
...

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.

On Mon, 4 Feb 2008, in microsoft.public.excel.charting,
rrupp said:

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?