Data Bars

[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

 

[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

 

[Winston]

Joel,

I'd like percentage.

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

 

[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