Hello
I have problem to find option which I need to work with.
I need a bar next to a number.
Like this
Really need help with this
because chart is out on the side and I need it next to a number.
Thanks.
Hello
I have problem to find option which I need to work with.
I need a bar next to a number.
Like this
Really need help with this
because chart is out on the side and I need it next to a number.
Thanks.
You could use Data bars, within Conditional Formatting, to do that.
To get the exact look you may need to use 2 columns of values. The right column would hold the CF data bars with no value shown
https://www.contextures.com/excel-co...data-bars.html
Another way would be to use this in B2:
=REPT("|",A2)
then copy down. You could use other symbols than the pipe character.
Hope this helps.
Pete
Thanks a lot guys
You may also find Sparklines useful. They won't show bars but they will show a line representation of a data series in a single cell.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks