Bar chart problem

[austexcal]

Hi,
Created this simple chart but I can't figure out why the bar doesn'
reach up to the horiz. line that it corresponds with... 2.0 and 2.5. Th
bars a noticeably shorter! Ideas?
thanks,
Auste

+-------------------------------------------------------------------
|Filename: example.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=335
+-------------------------------------------------------------------

 

[Spencer101]

Hi,
Created this simple chart but I can't figure out why the bar doesn'
reach up to the horiz. line that it corresponds with... 2.0 and 2.5. Th
bars a noticeably shorter! Ideas?
thanks,
Austex

Hi Austex,

Very hard to say without seeing the workbook itself.

S

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[austexcal]

I've attached the spreadsheet. it's pretty simple and straigh
forward...I think.

Hi Austex,

Very hard to say without seeing the workbook itself.

S

+-------------------------------------------------------------------
|Filename: BusData.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=345
+-------------------------------------------------------------------

 

[Spencer101]

I've attached the spreadsheet. it's pretty simple and straigh
forward...I think.

Hi,

It's because your numbers are rounded up. But the graph doesn't look a
them in that way.

For example the number in cell B16 is "2.45478036175711", which on
scale of 0-3 shown on the axis to the right of the graph, is quite a bi
less than 2.5

If you round the figures up to 1 decimal place rather than just displa
the numbers that way, all will look as you expect.

Are the numbers in the cells that create the graph created usin
formulas by any chance? If so, you could build in a =ROUND() element t
the formula to take care of this for you.

Hope that's of help.
Let us know if you need more assistance.

S

+-------------------------------------------------------------------
+-------------------------------------------------------------------