EXCEL charts and cell locking help

[MRBURGE]

Question 1
i am using excel 2000 and i have charts that show the percentage an item is recieved, but if an item has been recieved 100% of the time the bar charts y-axis goes up to 120% with the bar at 100% when its never going to go higher than 100%. So is there any way that i can stop it at 100%.

Question 2
The same system uses 1 and 0 to record whether an item is recieved, 1 being recieved and 0 not, the 1s are used to calculate a percentage over 5 days (by SUM the 5 days and depending on the total you get a percentage, 0=0% 1=20% 2=40% 3=60% 4=80% 5=100%) but if some one enters 11 instead of 1 the percentage will be about 240%. so is there any way i can make the cells only accept 0 or 1 and nothing else. I would like this part to be easy to implement because the system counts 120 items on 20 routes over the course of a year and each route is on a different sheet, all 20 routes follow an identical format

 

[BlueHorizon]

Hi,
Question 1:
Select the Y Axis on the chart and, on the chart toolbar, click the Format Axis icon. Click on the Scale tab and set the Maximum to 100.

Question 2:
Select the range of cells. Click on the Data menu. Select Validation. In the first drop down, select Text Length. IN the second drop down, select Equal to. In the last box, enter 2.

Hope this helps,


Best,
Blue Horizon

http://www.bluehorizontraining.com