Excel TV ExcelTV
Excel Charts, Graphs & Data Visualization

Fonts for Filled In-Cell Bars: Excel Challenge

Updated
Fonts for Filled In-Cell Bars: Excel Challenge

Hey folks! Welcome. Excel TV wishes you a very happy new year. Excel Author Jordan Goldmeier is ready with the first Excel challenge in 2016, but as usual before looking at this episode’s challenge, let us have a look at answer to previous episode’s challenge.

Last Week’s Challenge

Correct Answer from last week’s Challenge

If you remember, last episode’s challenge was on Excel Colors. Jordan asked how the value of RGB (R,G,B) is calculated? So, here is the answer.

If you remember converting numbers from one number system to another number system in school, then this would help you to answer this challenge. Here you need to consider the base as 256.

So, RGB (R,G,B) is calculated as R*256^0 + R * 256^1 + R*256^2

Here, RGB (130, 210, 11) = 774786 is calculated in the same way.

Hope you got it! Interesting right?

Last episode’s winner is “Ryan Tretter”. Congratulations!

What are the Fonts That Make Bars Look Filled & Complete

Now, Jordan comes up with this week’s Excel challenge and here it goes,

You can create in-cell Sparklines using the REPT formula and the “pipe” | symbol. There are two commonly used fonts in this trick that will make the bar look filled in and complete. Name one of those fonts.

Hurry up to Answer

You know the answer? Then what are you waiting for? Comment your answer below this post or answer us through Facebook. You can even tweet answer @ExcelTv. Hurry Up!

Written by

Sridhar Belide
Sridhar BelideB.Tech. Computer Science, JNTUH10+ years in software engineering

Software Engineer, Wells Fargo

  • React
  • UI Frameworks
  • Front-end Development
Sridhar Belide is a skilled software engineer with over a decade of experience in the industry. Currently working at Wells Fargo since December 2018, he focuses on developing UI frameworks for front-end applications using React. Before joining Wells Fargo, Sridhar spent five years and four months at Tata Consultancy Services, where he held the position of IT Analyst. He also has experience as a Community Manager for Impact SoftTech Pvt. Ltd. EALP and as a Software Research and Development Engineer at NSN - Nokia Solutions and Networks. Sridhar holds a Bachelor of Technology (B.Tech.) in Computer Science from JNTUH, demonstrating his strong foundation in the field.

Read more articles by Sridhar Belide

Editorial standards

Fact Checking & Editorial Guidelines

Every article on Excel TV is held to a published editorial standard. The goal: accurate, current, and useful — without filler.

  1. Expert review. Drafts on technical Excel topics are reviewed by a contributor with hands-on, working knowledge of the feature being covered.
  2. Source validation. Claims about Excel behavior are tested in current Microsoft 365 builds. Third-party product claims are sourced from the vendor's own documentation.
  3. Disclosure. Affiliate links, sponsorships, and any commercial relationships that influenced a piece are disclosed in-line and at the foot of the article.
  4. Updates. Articles are revisited when Microsoft ships changes that affect the content. The most recent revision date is shown on every post.

Spot a problem? Email editor@excel.tv and we will look at it.

Subject-matter review

Reviewed by Subject Matter Experts

Technical Excel articles are reviewed by contributors with verifiable, hands-on experience in the topic — not generalist editors.

  • Qualified reviewers. Reviewers include Microsoft Excel MVPs, working business-intelligence practitioners, and Excel TV editorial staff. See each author's page for credentials.
  • Current to a known Excel build. Procedural articles state which Excel version they were validated against. Where Microsoft has since changed behavior, the article carries an inline update note.
  • Clarity check. Reviewers verify steps are reproducible by a reader at the assumed skill level — not just technically correct in a vacuum.

Want to contribute or review for Excel TV? See the about page.

Comments (5)

Historical comments preserved from the WordPress archive. Commenting is no longer active.

  1. Puneet Gogia

    We can use (Playbill – Font Size-10, Stencil – Font Size – 10. & Haettenschweiler – Font Size -11) for a perfect in cell bar.

    http://1drv.ms/1KCdD2O

  2. Squalle

    As well as the ones mentioned above: Playbill in size multiples of 20 (20, 40, 60, etc), Stencil (size 10, 14 and a few others) & Haettenschweiler (sizes 11 & 16).

    But I’m going to go with Britannic Bold (size 11, or most any even numbered size (12, 16, 18, etc).

  3. Arvapally

    Hell All,
    Greetings for the day!!!

    Font Names are:
    1. Britannic Bold
    2. Haettenschweiler

    Regards,
    Arvapally
    9848681465

    1. Jordan Goldmeier

      Congratulations! You’ve won our contest. Please email me jpo645 (at) gmail to claim your prize!

  4. David H

    1. Playbill
    2. Stencil