Charting close data

[cm_027]

Hello, all:

I am trying to perform some comparisons and trending for system availability on the order of 5 9s, that's 3 significant digits of precision ranging between 95% and 100%.

I am having a hard time representing this data in a way that shows very slight variations.

Take this table, for example:

Please Login or Register  to view this content.

Sys 2 shows as a straight line smashed up at the top when shown on a scale of 95 to 100. If I change the scale, it makes comparing Sys 1 with Sys 2 impossible.

What is the best way of representing data with this many significant digits?

Numeric representation, which is my favorite for this data, does not properly show the data since it tends to "blur" together.

Attached is a simple worksheet to show the dilemma.

I greatly appreciate any guidance.

[Bryan Hessey]

Hello, all:

I am trying to perform some comparisons and trending for system availability on the order of 5 9s, that's 3 significant digits of precision ranging between 95% and 100%.

I am having a hard time representing this data in a way that shows very slight variations.

Take this table, for example:

Please Login or Register  to view this content.

Sys 2 shows as a straight line smashed up at the top when shown on a scale of 95 to 100. If I change the scale, it makes comparing Sys 1 with Sys 2 impossible.

What is the best way of representing data with this many significant digits?

Numeric representation, which is my favorite for this data, does not properly show the data since it tends to "blur" together.

Attached is a simple worksheet to show the dilemma.

I greatly appreciate any guidance.

Hi,

always difficult, since the variation in Sys2 is so small by comparison.

Perhaps something like the attached might help, where hiding rows 3 through 6 will allow comparisons of the remaining sets.

hth
---