Set chart to show positive numbers only
 

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

Set chart to show positive numbers only
 

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" wrote in message
oups.com...
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

Set chart to show positive numbers only
 

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 a

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

Set chart to show positive numbers only
 

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

"San" wrote in message
ups.com...

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 a

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

Set chart to show positive numbers only
 

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!

Set chart to show positive numbers only
 

Congratulations!
Joerg

"San" wrote in message
ups.com...

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!