| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Bars
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Bars
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Bars
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Bars
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation - Scroll Bars | Excel Discussion (Misc queries) | |||
| How do I get different error bars within data set? | Charts and Charting in Excel | |||
| Data Bars based on other cells | Excel Discussion (Misc queries) | |||
| How can I change a graph with 2 bars,2 lines to 3 bars, 1 line? | Charts and Charting in Excel | |||
| Lost all my menu bars and tool bars | Excel Discussion (Misc queries) | |||
Hybrid Mode
