Data Bars

W

Winston

I have two values: C11 is total disk size. C12 is unused. I'd like C13 to
show a Data Bar that displays amount of used space. Every way I try it, I get
a bar that looks like 50%. So . . . can Data Bars be used for this, and if
so, how? Thanks
 
J

Joel

Do you want the data to be plotted as amount or percentage?

Amounts would be
C11 C12 C13
15GB 10GB =C11-C12


Perecnetage would be (shown are fractions) format as percentage
C11 C12 C13
15GB/15GB 10GB/15GB =C11-C12
 
W

Winston

Joel,

I'd like percentage.

Joel said:
Do you want the data to be plotted as amount or percentage?

Amounts would be
C11 C12 C13
15GB 10GB =C11-C12


Perecnetage would be (shown are fractions) format as percentage
C11 C12 C13
15GB/15GB 10GB/15GB =C11-C12
Click to expand...
 
P

Pete_UK

The following formula will give you a visual representation of disc
usage in C13 - widen the column to suit:

=REPT("|",100*(C11-C12)/C11)&REPT(" ",100*C12/C11)&"|"

Unfortunately the space character is not the same width as the pipe
character, so the overall length of the bar will vary if you change
C12.

Hope this helps.

Pete
 
Top