Set chart to show positive numbers only

[San]

I have been into the formt axis menu and I don't understand jack! I
have negative numbers in my source but I only want the chart to show
the positive values. If you pls you can do it step by step so you don't
lose me :)

thx

[Joerg]

1)Create your chart
2) Right click the value axis (assuming it's the Y-axis)
3) Format axis => Scale
4) Set Minimum to zero

That's it,

Joerg

Post by San
I have been into the formt axis menu and I don't understand jack! I
have negative numbers in my source but I only want the chart to show
the positive values. If you pls you can do it step by step so you don't
lose me :)
thx

[San]

Post by Joerg
1)Create your chart
2) Right click the value axis (assuming it's the Y-axis)
3) Format axis => Scale
4) Set Minimum to zero
That's it,
Joerg

In the format axis => scale

it says that the minimum value is 1.

"Category(X) axis scale" -- shouldn't is say (Y) axis scale? Can't
find this

my options are:

1.

Value Y axis crosses at category number (1) '1 is minimum.

2.

Numbers of categories between thick-mark labels also set to 1 which is
minimum

3.

Numbers of categories between thick-mark1 = 1

Value (Y) crosses between categories 'this is marked

Categories in reverrs order

Value(Y)axis crosses at maximum category


thats all I can see. can't finde anywhere where is says minimum.

I am using excel 2000

thx

[Joerg]

You have to right click the Y axis, not the X axis.
Joerg

Post by San

Post by Joerg
1)Create your chart
2) Right click the value axis (assuming it's the Y-axis)
3) Format axis => Scale
4) Set Minimum to zero
That's it,
Joerg

In the format axis => scale
it says that the minimum value is 1.
"Category(X) axis scale" -- shouldn't is say (Y) axis scale? Can't
find this
1.
Value Y axis crosses at category number (1) '1 is minimum.
2.
Numbers of categories between thick-mark labels also set to 1 which is
minimum
3.
Numbers of categories between thick-mark1 = 1
Value (Y) crosses between categories 'this is marked
Categories in reverrs order
Value(Y)axis crosses at maximum category
thats all I can see. can't finde anywhere where is says minimum.
I am using excel 2000
thx

[San]

yeah I just found out. I was trying to click on the lefthand
side...which didn't work. But then I thought maybe on the right
side...it is odd that it is located on this side not...logical.

many thx it all works now!

[Joerg]

Congratulations!
Joerg

Post by San
yeah I just found out. I was trying to click on the lefthand
side...which didn't work. But then I thought maybe on the right
side...it is odd that it is located on this side not...logical.
many thx it all works now!