# Fonts That Make Bars Look Filled & Complete – Excel Challenges

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.

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

Tags

#### You may also like

February 26, 2015

## What Year Were Sparklines Added to Excel? â€“ Excel Challenges

What Year Were Sparklines Added to Excel? – Excel Challenges

September 9, 2014

## Info Graphics with Excel

Info Graphics with Excel

February 12, 2016

## Fonts That Make Bars Look Filled & Complete â€“ Excel Challenges

Fonts That Make Bars Look Filled & Complete – Excel Challenges

August 28, 2012

## Details on Demand: Bring up details on a graph with Excel rollovers

Details on Demand: Bring up details on a graph with Excel rollovers

August 21, 2013

## Another way to do bullet graphs in Excel

Another way to do bullet graphs in Excel

June 19, 2012

## Rollovers for Gantt Charts

Rollovers for Gantt Charts
• Squalle says:

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

• Arvapally says:

Hell All,
Greetings for the day!!!

Font Names are:
1. Britannic Bold
2. Haettenschweiler

Regards,
Arvapally
9848681465

• Jordan Goldmeier says:

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

• David H says:

1. Playbill
2. Stencil