I just can't seem to figure out how to do this. My business group has a web
server and they want to include the server up time in their quarterly
reports. Basically you can imagine that the numbers are all 99.xx. The
graph that they prepared automatically formats the values based upon the
values for teh chart...so it looks like the server had a really bad month
last month when it was really only down for for momments So...I how do I
format the y axis to use the percentage scale of 0 to 100% instead of 99.95%
to 100%. That way the chart will give a better (more accurate) presentation
of up time than what they had. Thanks for all of your help =)

Right click on the axis, choose Format.... On the scale tab (or in 2007 on
the first tab you see) enter 0 for the axis minimum.

On a scale of 0 to 100, anything above 99 will simply look like a straight
line.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"H0MELY" wrote in message
...
I just can't seem to figure out how to do this. My business group has a
web
server and they want to include the server up time in their quarterly
reports. Basically you can imagine that the numbers are all 99.xx. The
graph that they prepared automatically formats the values based upon the
values for teh chart...so it looks like the server had a really bad month
last month when it was really only down for for momments So...I how do I
format the y axis to use the percentage scale of 0 to 100% instead of
99.95%
to 100%. That way the chart will give a better (more accurate)
presentation
of up time than what they had. Thanks for all of your help =)

Thank You...I knew it had to be there I was just missing it,. Thank You So
Much...and the straight line is actually what I was looking for ;) Thanks

"Jon Peltier" wrote:

Right click on the axis, choose Format.... On the scale tab (or in 2007 on
the first tab you see) enter 0 for the axis minimum.

On a scale of 0 to 100, anything above 99 will simply look like a straight
line.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"H0MELY" wrote in message
...
I just can't seem to figure out how to do this. My business group has a
web
server and they want to include the server up time in their quarterly
reports. Basically you can imagine that the numbers are all 99.xx. The
graph that they prepared automatically formats the values based upon the
values for teh chart...so it looks like the server had a really bad month
last month when it was really only down for for momments So...I how do I
format the y axis to use the percentage scale of 0 to 100% instead of
99.95%
to 100%. That way the chart will give a better (more accurate)
presentation
of up time than what they had. Thanks for all of your help =)

You format the y-axis and change the scale to 0 to 1 (or 0 to 100%)
Right click by-axis
Open the Format Axis tab
Set the scale (min 0, max 1) and click OK
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme


"H0MELY" wrote in message
...
I just can't seem to figure out how to do this. My business group has a
web
server and they want to include the server up time in their quarterly
reports. Basically you can imagine that the numbers are all 99.xx. The
graph that they prepared automatically formats the values based upon the
values for teh chart...so it looks like the server had a really bad month
last month when it was really only down for for momments So...I how do I
format the y axis to use the percentage scale of 0 to 100% instead of
99.95%
to 100%. That way the chart will give a better (more accurate)
presentation
of up time than what they had. Thanks for all of your help =)