bobhc
Excel Ninja
Good day all
I have been trying to make an in cell bar chart to show different numeric values and have come up with this, others may find it of use, my data is in column A, first row is headers.
In the free column insert this code in the second cell and copy down:-
"=REPT("|",(A2)"), you may need to hold down the Alt key and enter 124 on the numeric keypad to the right, not the keys at the top "|"
The font used is script at 9 points and set to bold colour the font to your liking.
If your numeric vales are large you may wish to do some ting like this "=REPT("|",A4/2)"
I have seen some thing similar to this but can not remember where.
I have been trying to make an in cell bar chart to show different numeric values and have come up with this, others may find it of use, my data is in column A, first row is headers.
In the free column insert this code in the second cell and copy down:-
"=REPT("|",(A2)"), you may need to hold down the Alt key and enter 124 on the numeric keypad to the right, not the keys at the top "|"
The font used is script at 9 points and set to bold colour the font to your liking.
If your numeric vales are large you may wish to do some ting like this "=REPT("|",A4/2)"
I have seen some thing similar to this but can not remember where.
