Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Bars
How can I place data bars in column N with respect to percentages in column
CI ranging from 0 - 100? I am doing this so to overlap some pertinent information. -- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Bars
What XL version ?
Tim "Doug" wrote in message ... How can I place data bars in column N with respect to percentages in column CI ranging from 0 - 100? I am doing this so to overlap some pertinent information. -- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Bars
2007
-- Thank you! "Tim Williams" wrote: What XL version ? Tim "Doug" wrote in message ... How can I place data bars in column N with respect to percentages in column CI ranging from 0 - 100? I am doing this so to overlap some pertinent information. -- . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Bars
Don't have XL2007 to try this, but code here might help. Most of the examples I've seen are formatting the cells containing the actual values though... http://www.ozgrid.com/forum/showthre...lter&fid=43221 Tim On Dec 22, 11:44*am, Doug wrote: 2007 -- Thank you! "Tim Williams" wrote: What XL version ? Tim "Doug" wrote in message ... How can I place data bars in column N with respect to percentages in column CI ranging from 0 - 100? I am doing this so to overlap some pertinent information. -- .- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Bars
You'll just need to get the % values from column CI into column N
"=CI4" in N4 (for example) should do it. Tim "Doug" wrote in message ... Do you know if there is a formula that I might be able to place in the CF that might link the two? -- Thank you! "Tim Williams" wrote: Don't have XL2007 to try this, but code here might help. Most of the examples I've seen are formatting the cells containing the actual values though... http://www.ozgrid.com/forum/showthre...lter&fid=43221 Tim On Dec 22, 11:44 am, Doug wrote: 2007 -- Thank you! "Tim Williams" wrote: What XL version ? Tim "Doug" wrote in message ... How can I place data bars in column N with respect to percentages in column CI ranging from 0 - 100? I am doing this so to overlap some pertinent information. -- .- Hide quoted text - - Show quoted text - . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Bars are the wrong length for data in cell | Excel Discussion (Misc queries) | |||
Customise error bars on individual bars in a bar chart 2007 | Charts and Charting in Excel | |||
Data Bars | 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) |