ExcelBanter - Data Bars

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Bars (https://www.excelbanter.com/excel-discussion-misc-queries/180719-data-bars.html)

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

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" wrote:

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,

I'd like percentage.

"Joel" wrote:

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" wrote:

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

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

On Mar 20, 2:06*pm, Winston wrote:
Joel,

I'd like percentage.

"Joel" wrote:
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" wrote:

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- Hide quoted text -

- Show quoted text -