ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Y axis to cross at zero (https://www.excelbanter.com/charts-charting-excel/99479-y-axis-cross-zero.html)

Paddy

Y axis to cross at zero
 
I have line graph of sines of angles 0 deg to 360 deg. I need the X axis to
show X-axis corresponding to angles 0, 90, 27, 360. But if I set
tick-marks every 90, the labels read 1,91,181,271,361.

This is because the "Scale" dialogue has "Value (Y) axis crosses at
category number: 1". This cannot be set to zero; it must be in the range 1
to 39999. How can I set the X-axis to commence at zero?

What point am I missing here???

Thanks

Paddy



Paddy

Y axis to cross at zero
 

"Paddy" wrote :

I have line graph of sines of angles 0 deg to 360 deg. I need the X axis
to show X-axis corresponding to angles 0, 90, 27, 360. But if I set
tick-marks every 90, the labels read 1,91,181,271,361.

This is because the "Scale" dialogue has "Value (Y) axis crosses at
category number: 1". This cannot be set to zero; it must be in the range
1 to 39999. How can I set the X-axis to commence at zero?


Found it. I had forgotten - use scatter graphs rather than than line graph.

Thanks

Paddy



James Silverton

Y axis to cross at zero
 
Paddy wrote on Sun, 16 Jul 2006 01:26:21 +1000:

?? I have line graph of sines of angles 0 deg to 360 deg. I
?? need the X axis to show X-axis corresponding to angles 0,
?? 90, 27, 360. But if I set tick-marks every 90, the
?? labels read 1,91,181,271,361.
??
?? This is because the "Scale" dialogue has "Value (Y) axis
?? crosses at category number: 1". This cannot be set to
zero; it
?? must be in the range 1 to 39999. How can I set the X-axis
?? to commence at zero?

P Found it. I had forgotten - use scatter graphs rather than
P than line graph.

P Thanks

Don't worry! You wouldn't have been the first to rush into print
with that question or answer. It's almost on the level of how to
plot empty values :-)

James Silverton.


Paddy

Y axis to cross at zero
 

"James Silverton" wrote:

Don't worry! You wouldn't have been the first to rush into print with that
question or answer. It's almost on the level of how to plot empty values
:-)


Ah! But you may not appreciate the deeper import of my Alzheimic episode!
I have a class of High School kids in Excel next week - haven't used Excel
for a while. "She'll be right" quoth I blithely ..........

Confucius say: Use It or Lose It !!!!

:-)

Paddy




All times are GMT +1. The time now is 11:14 PM.

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