View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Joerg Joerg is offline
external usenet poster
 
Posts: 138
Default 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