| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel change a group of positive numbers to negitive numbers | Excel Discussion (Misc queries) | |||
| Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
| Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
| change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
| convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions | |||
![San[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
