ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel 2007 - Chart not working (https://www.excelbanter.com/charts-charting-excel/257196-excel-2007-chart-not-working.html)

QB

Excel 2007 - Chart not working
 
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[_3_]

Excel 2007 - Chart not working
 
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



All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com