Excel 2007 - Chart not working

[QB]

First, I must say that Excel 2007 charting is much worse to use than 97, 2000
or 2003! It is not intuitive as it was with previous versions!

I created a very simple line chart. The problem I am experiencing is that
is start my initial value at 0%, which is fine and then promptly goes upto
100% and stays there for all the other points. What I love even more is that
when I place my cursor over each point it actually give the proper values
(73%, 61%,...) but always displays the line at 100%???

Anyone ever seen this problem before?

Thank you for your assistance,

QB

 

[trip_to_tokyo]

Double click the Y (Value) axis / this should highlight that axis by placing
a box around it / right click / Format Axis . . . / Format Axis pane should
launch with Axis options highlighted in orange on left hand side / check
Minimum: and Maximum: settings on the right hand side and adjust them if
necessary.

Please hit Yes if my comments have helped.

Thanks.