Forum Discussion
How do I make a data bar display as (current value) / (max) rather than a single number.
I have a data bar in project that is meant to display how much experience a character needs to level up. At the current moment, I have the max value (100) linked to a cell elsewhere - and typing in a...
Not sure if I misread, but I am able to get the number 50 on my data bar, what i'm trying to do is - rather than just display 50 - have the text in the cell say "50/100".
- Rather than use the fixed number '100', is it possible - in making the custom format, to reference a cell number (such as a1, a2 etc)?
jvs95 Tried with custom formatting with fractions but that doesn't seem to work. A work around could be that you put the "/nnn" outside the cell with the value and the bar. But then it's easier to include the Level-up value in a hidden column (B in the attached file).
Can't think of another way right now.