Forum Discussion
jvs95
Jul 18, 2021Copper Contributor
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 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.
5 Replies
Sort By
- Riny_van_EekelenPlatinum Contributor
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.
- jvs95Copper ContributorNot 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".
- Riny_van_EekelenPlatinum Contributor