bar on chart isn't representing correctly
 

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

bar on chart isn't representing correctly
 

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.

bar on chart isn't representing correctly
 

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?