How do I make a data bar display as (current value) / (max) rather than a single number.

%3CLINGO-SUB%20id%3D%22lingo-sub-2559289%22%20slang%3D%22en-US%22%3EHow%20do%20I%20make%20a%20data%20bar%20display%20as%20(current%20value)%20%2F%20(max)%20rather%20than%20a%20single%20number.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2559289%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20data%20bar%20in%20project%20that%20is%20meant%20to%20display%20how%20much%20experience%20a%20character%20needs%20to%20level%20up.%20At%20the%20current%20moment%2C%20I%20have%20the%20max%20value%20(100)%20linked%20to%20a%20cell%20elsewhere%20-%20and%20typing%20in%20a%20value%20like%2050%20does%20actually%20make%20the%20bar%20visually%2050%2F50%20but%20I%20want%20the%20numbers%20inside%20the%20bar%20to%20show%20as%2050(slash)100%20(50%2F100)%20rather%20than%20just%2050.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2559289%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2559375%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20make%20a%20data%20bar%20display%20as%20(current%20value)%20%2F%20(max)%20rather%20than%20a%20single%20number.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2559375%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1103873%22%20target%3D%22_blank%22%3E%40jvs95%3C%2FA%3E%26nbsp%3BYou%20could%20use%20conditional%20formatting%20for%20this%2C%20as%20demonstrated%20in%20the%20picture%20below%20(taken%20on%20a%20Mac%2C%20but%20similar%20for%20PC)%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-07-18%20at%2004.29.00.png%22%20style%3D%22width%3A%20528px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296603i3D2AB0415800B558%2Fimage-dimensions%2F528x355%3Fv%3Dv2%22%20width%3D%22528%22%20height%3D%22355%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-07-18%20at%2004.29.00.png%22%20alt%3D%22Screenshot%202021-07-18%20at%2004.29.00.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFormat%20the%20cell%20with%20the%20experience%20number%20as%20a%20Data%20Bar%20with%20a%20minimum%20of%200%20and%20a%20maximum%20of%20100.%20%26nbsp%3BThen%20the%20number%2050%20will%20show%20as%20a%20bar%20covering%20half%20the%20cell%20with.%20Format%20the%20bar%20to%20your%20liking.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2559410%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20make%20a%20data%20bar%20display%20as%20(current%20value)%20%2F%20(max)%20rather%20than%20a%20single%20number.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2559410%22%20slang%3D%22en-US%22%3ENot%20sure%20if%20I%20misread%2C%20but%20I%20am%20able%20to%20get%20the%20number%2050%20on%20my%20data%20bar%2C%20what%20i'm%20trying%20to%20do%20is%20-%20rather%20than%20just%20display%2050%20-%20have%20the%20text%20in%20the%20cell%20say%20%2250%2F100%22.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2559495%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20make%20a%20data%20bar%20display%20as%20(current%20value)%20%2F%20(max)%20rather%20than%20a%20single%20number.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2559495%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1103873%22%20target%3D%22_blank%22%3E%40jvs95%3C%2FA%3E%26nbsp%3BI%20misunderstood!%20Use%20a%20custom%20format%20like%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-07-18%20at%2006.41.44.png%22%20style%3D%22width%3A%20114px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296608i5670A1C26BE91434%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-07-18%20at%2006.41.44.png%22%20alt%3D%22Screenshot%202021-07-18%20at%2006.41.44.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EFile%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

@jvs95 You could use conditional formatting for this, as demonstrated in the picture below (taken on a Mac, but similar for PC)

Screenshot 2021-07-18 at 04.29.00.png

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.

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".

@jvs95 I misunderstood! Use a custom format like 

Screenshot 2021-07-18 at 06.41.44.png

File attached.

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.