Forum Discussion

andrew_jmdata9's avatar
andrew_jmdata9
Copper Contributor
Feb 21, 2019
Solved

Bar length in cell based on value in another cell

Hi, We have a report where a column shows a value, usually between 1 and 200.    We want to have a horizontal bar in the next cell whose length is based on the cell value.   Something like below,...
Excel Formula
  • Twifoo's avatar
    Twifoo
    Feb 21, 2019
    Let me correct myself. The formula in B2 should be:
    =REPT(“|”,MIN(A2,99)&
    IF(A2>99,
    “X”&REPT(“|”,A2-100),
    “”)
andrew_jmdata9's avatar
andrew_jmdata9
Copper Contributor
Feb 21, 2019

Hi Rich, Thanks for the speedy response. I actually have 250 rows so probably too many for a graph.

 

I have seen this done before but can't recall how. At the moment, I am using the rept() function to show "X" as representative of cell value. It's ok but I really would like a continuous bar. 

 

Cheers

Andrew

Rich99's avatar
Rich99
Iron Contributor
Feb 21, 2019
It would easily stretch to 250 rows

Resources