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

 

[San]

Joerg skrev:

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

 

[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