Prev: Loss of referenced data (Titles) when upgrading from Excel 2000to 2007
Next: Excel 2007 - Add straight line to chart
From: QB on 23 Feb 2010 19:46
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
From: trip_to_tokyo on 24 Feb 2010 00:16
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.

"QB" wrote:

> 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
 | 
Pages: 1
Prev: Loss of referenced data (Titles) when upgrading from Excel 2000to 2007
Next: Excel 2007 - Add straight line to chart