Hi, does anybody know how to do this?:
Say I've got an in-cell chart using the REPT function
=REPT(" ",(B12/$C$3))&"|"&REPT(".",(C12/$C$3))&CHAR(149)&REPT(".",(D12/$C$3))&"|"
...where c3 is
I'd like to have scaling factor in C3 automatically adjusted so that the chart always stays within the width of columns B & C, irrespective of the values in in B12, C12 & D12.
Is it possible?
Say I've got an in-cell chart using the REPT function
=REPT(" ",(B12/$C$3))&"|"&REPT(".",(C12/$C$3))&CHAR(149)&REPT(".",(D12/$C$3))&"|"
...where c3 is
I'd like to have scaling factor in C3 automatically adjusted so that the chart always stays within the width of columns B & C, irrespective of the values in in B12, C12 & D12.
Is it possible?
