Jul 17 2021 06:00 PM
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 value like 50 does actually make the bar visually 50/50 but I want the numbers inside the bar to show as 50(slash)100 (50/100) rather than just 50.
Jul 17 2021 07:35 PM
@jvs95 You could use conditional formatting for this, as demonstrated in the picture below (taken on a Mac, but similar for PC)
Format the cell with the experience number as a Data Bar with a minimum of 0 and a maximum of 100. Then the number 50 will show as a bar covering half the cell with. Format the bar to your liking.
Jul 17 2021 08:40 PM
Jul 17 2021 09:42 PM
Jul 17 2021 10:14 PM
Jul 17 2021 10:40 PM - edited Jul 17 2021 10:42 PM
@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.