chandoo.org Open in urlscan Pro
67.222.17.217 Public Scan

Back to summary

URL:
https://chandoo.org/wp/creating-in-cell-bar-charts-histograms-in-excel/
Submission: On July 17 via manual (July 17th 2023, 4:36:45 pm UTC) from US — Scanned from DE

Form analysis
3 forms found in the DOM

GET https://chandoo.org/wp

<form class="elementor-search-form" action="https://chandoo.org/wp" method="get" role="search">
  <div class="elementor-search-form__toggle" tabindex="0" role="button">
    <i aria-hidden="true" class="fas fa-search"></i> <span class="elementor-screen-only">Search</span>
  </div>
  <div class="elementor-search-form__container">
    <label class="elementor-screen-only" for="elementor-search-form-67857459">Search</label>
    <input id="elementor-search-form-67857459" placeholder="Search..." class="elementor-search-form__input" type="search" name="s" value="">
    <div class="dialog-lightbox-close-button dialog-close-button" role="button" tabindex="0">
      <i aria-hidden="true" class="eicon-close"></i> <span class="elementor-screen-only">Close this search box.</span>
    </div>
  </div>
</form>

POST https://app.convertkit.com/forms/1055607/subscriptions

<form action="https://app.convertkit.com/forms/1055607/subscriptions" class="seva-form formkit-form" method="post" data-sv-form="1055607" data-uid="8bc636d501" data-format="inline" data-version="5" min-width="400 500 600 700 800">
  <div data-style="clean">
    <ul class="formkit-alert formkit-alert-error" data-element="errors" data-group="alert"></ul>
    <div data-element="fields" data-stacked="true" class="seva-fields formkit-fields">
      <div class="formkit-field"><input type="text" class="formkit-input" aria-label="Your first name" style="border-color:#e3e3e3;border-radius:4px;color:#000;font-weight:400" name="fields[first_name]" placeholder="Your first name"></div>
      <div class="formkit-field"><input type="text" class="formkit-input" name="email_address" style="border-color:#e3e3e3;border-radius:4px;color:#000;font-weight:400" placeholder="Your email address" required=""></div>
      <div class="formkit-field">
        <fieldset data-group="checkboxes" class="formkit-9127" type="Custom" order="2" save_as="Tag" group="field"></fieldset>
      </div>
      <div class="formkit-field">
        <fieldset data-group="checkboxes" class="formkit-681" type="Custom" order="3" save_as="Tag" group="field">
          <legend style="color:#000;font-weight:400">You want to learn</legend>
          <div class="formkit-checkboxes" data-element="tags-checkboxes" data-group="checkbox" style="border-color:#e3e3e3;border-radius:4px;color:#000;font-weight:400"><input type="checkbox" class="formkit-checkbox" id="tag-1740694-1093939"
              name="tags[]" value="1093939"><label for="tag-1740694-1093939">Excel</label></div>
          <div class="formkit-checkboxes" data-element="tags-checkboxes" data-group="checkbox" style="border-color:#e3e3e3;border-radius:4px;color:#000;font-weight:400"><input type="checkbox" class="formkit-checkbox" id="tag-1740694-1093941"
              name="tags[]" value="1093941"><label for="tag-1740694-1093941">Power BI</label></div>
        </fieldset>
      </div><button data-element="submit" class="formkit-submit formkit-submit" style="background-color:#009603;border-radius:5px;color:#fff;font-weight:700">
        <div class="formkit-spinner">
          <div></div>
          <div></div>
          <div></div>
        </div><span>Subscribe</span>
      </button>
    </div>
  </div>
  <style>
    .formkit-form[data-uid="8bc636d501"] * {
      font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;
      box-sizing: border-box;
    }

    .formkit-form[data-uid="8bc636d501"] {
      -webkit-font-smoothing: antialiased;
      -moz-osx-font-smoothing: grayscale;
    }

    .formkit-form[data-uid="8bc636d501"] legend {
      border: none;
      font-size: inherit;
      margin-bottom: 10px;
      padding: 0;
      position: relative;
      display: table;
    }

    .formkit-form[data-uid="8bc636d501"] fieldset {
      border: 0;
      padding: 0.01em 0 0 0;
      margin: 0;
      min-width: 0;
    }

    .formkit-form[data-uid="8bc636d501"] body:not(:-moz-handler-blocked) fieldset {
      display: table-cell;
    }

    .formkit-form[data-uid="8bc636d501"] h1,
    .formkit-form[data-uid="8bc636d501"] h2,
    .formkit-form[data-uid="8bc636d501"] h3,
    .formkit-form[data-uid="8bc636d501"] h4,
    .formkit-form[data-uid="8bc636d501"] h5,
    .formkit-form[data-uid="8bc636d501"] h6 {
      color: inherit;
      font-size: inherit;
      font-weight: inherit;
    }

    .formkit-form[data-uid="8bc636d501"] p {
      color: inherit;
      font-size: inherit;
      font-weight: inherit;
    }

    .formkit-form[data-uid="8bc636d501"][data-format="modal"] {
      display: none;
    }

    .formkit-form[data-uid="8bc636d501"][data-format="slide in"] {
      display: none;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-input,
    .formkit-form[data-uid="8bc636d501"] .formkit-select,
    .formkit-form[data-uid="8bc636d501"] .formkit-checkboxes {
      width: 100%;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-button,
    .formkit-form[data-uid="8bc636d501"] .formkit-submit {
      border: 0;
      border-radius: 5px;
      color: #ffffff;
      cursor: pointer;
      display: inline-block;
      text-align: center;
      font-size: 15px;
      font-weight: 500;
      cursor: pointer;
      margin-bottom: 15px;
      overflow: hidden;
      padding: 0;
      position: relative;
      vertical-align: middle;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-button:hover,
    .formkit-form[data-uid="8bc636d501"] .formkit-submit:hover,
    .formkit-form[data-uid="8bc636d501"] .formkit-button:focus,
    .formkit-form[data-uid="8bc636d501"] .formkit-submit:focus {
      outline: none;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-button:hover>span,
    .formkit-form[data-uid="8bc636d501"] .formkit-submit:hover>span,
    .formkit-form[data-uid="8bc636d501"] .formkit-button:focus>span,
    .formkit-form[data-uid="8bc636d501"] .formkit-submit:focus>span {
      background-color: rgba(0, 0, 0, 0.1);
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-button>span,
    .formkit-form[data-uid="8bc636d501"] .formkit-submit>span {
      display: block;
      -webkit-transition: all 300ms ease-in-out;
      transition: all 300ms ease-in-out;
      padding: 12px 24px;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-input {
      background: #ffffff;
      font-size: 15px;
      padding: 12px;
      border: 1px solid #e3e3e3;
      -webkit-flex: 1 0 auto;
      -ms-flex: 1 0 auto;
      flex: 1 0 auto;
      line-height: 1.4;
      margin: 0;
      -webkit-transition: border-color ease-out 300ms;
      transition: border-color ease-out 300ms;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-input:focus {
      outline: none;
      border-color: #1677be;
      -webkit-transition: border-color ease 300ms;
      transition: border-color ease 300ms;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-input::-webkit-input-placeholder {
      color: inherit;
      opacity: 0.8;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-input::-moz-placeholder {
      color: inherit;
      opacity: 0.8;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-input:-ms-input-placeholder {
      color: inherit;
      opacity: 0.8;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-input::placeholder {
      color: inherit;
      opacity: 0.8;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="dropdown"] {
      position: relative;
      display: inline-block;
      width: 100%;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="dropdown"]::before {
      content: "";
      top: calc(50% - 2.5px);
      right: 10px;
      position: absolute;
      pointer-events: none;
      border-color: #4f4f4f transparent transparent transparent;
      border-style: solid;
      border-width: 6px 6px 0 6px;
      height: 0;
      width: 0;
      z-index: 999;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="dropdown"] select {
      height: auto;
      width: 100%;
      cursor: pointer;
      color: #333333;
      line-height: 1.4;
      margin-bottom: 0;
      padding: 0 6px;
      -webkit-appearance: none;
      -moz-appearance: none;
      appearance: none;
      font-size: 15px;
      padding: 12px;
      padding-right: 25px;
      border: 1px solid #e3e3e3;
      background: #ffffff;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="dropdown"] select:focus {
      outline: none;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="checkboxes"] {
      text-align: left;
      margin: 0;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="checkboxes"] [data-group="checkbox"] {
      margin-bottom: 10px;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="checkboxes"] [data-group="checkbox"] * {
      cursor: pointer;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="checkboxes"] [data-group="checkbox"]:last-of-type {
      margin-bottom: 0;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="checkboxes"] [data-group="checkbox"] input[type="checkbox"] {
      display: none;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="checkboxes"] [data-group="checkbox"] input[type="checkbox"]+label::after {
      content: none;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="checkboxes"] [data-group="checkbox"] input[type="checkbox"]:checked+label::after {
      border-color: #ffffff;
      content: "";
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="checkboxes"] [data-group="checkbox"] input[type="checkbox"]:checked+label::before {
      background: #10bf7a;
      border-color: #10bf7a;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="checkboxes"] [data-group="checkbox"] label {
      position: relative;
      display: inline-block;
      padding-left: 28px;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="checkboxes"] [data-group="checkbox"] label::before,
    .formkit-form[data-uid="8bc636d501"] [data-group="checkboxes"] [data-group="checkbox"] label::after {
      position: absolute;
      content: "";
      display: inline-block;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="checkboxes"] [data-group="checkbox"] label::before {
      height: 16px;
      width: 16px;
      border: 1px solid #e3e3e3;
      background: #ffffff;
      left: 0px;
      top: 3px;
    }

    .formkit-form[data-uid="8bc636d501"] [data-group="checkboxes"] [data-group="checkbox"] label::after {
      height: 4px;
      width: 8px;
      border-left: 2px solid #4d4d4d;
      border-bottom: 2px solid #4d4d4d;
      -webkit-transform: rotate(-45deg);
      -ms-transform: rotate(-45deg);
      transform: rotate(-45deg);
      left: 4px;
      top: 8px;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-alert {
      background: #f9fafb;
      border: 1px solid #e3e3e3;
      border-radius: 5px;
      -webkit-flex: 1 0 auto;
      -ms-flex: 1 0 auto;
      flex: 1 0 auto;
      list-style: none;
      margin: 25px auto;
      padding: 12px;
      text-align: center;
      width: 100%;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-alert:empty {
      display: none;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-alert-success {
      background: #d3fbeb;
      border-color: #10bf7a;
      color: #0c905c;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-alert-error {
      background: #fde8e2;
      border-color: #f2643b;
      color: #ea4110;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-spinner {
      display: -webkit-box;
      display: -webkit-flex;
      display: -ms-flexbox;
      display: flex;
      height: 0px;
      width: 0px;
      margin: 0 auto;
      position: absolute;
      top: 0;
      left: 0;
      right: 0;
      width: 0px;
      overflow: hidden;
      text-align: center;
      -webkit-transition: all 300ms ease-in-out;
      transition: all 300ms ease-in-out;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-spinner>div {
      margin: auto;
      width: 12px;
      height: 12px;
      background-color: #fff;
      opacity: 0.3;
      border-radius: 100%;
      display: inline-block;
      -webkit-animation: formkit-bouncedelay-formkit-form-data-uid-8bc636d501- 1.4s infinite ease-in-out both;
      animation: formkit-bouncedelay-formkit-form-data-uid-8bc636d501- 1.4s infinite ease-in-out both;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-spinner>div:nth-child(1) {
      -webkit-animation-delay: -0.32s;
      animation-delay: -0.32s;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-spinner>div:nth-child(2) {
      -webkit-animation-delay: -0.16s;
      animation-delay: -0.16s;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-submit[data-active] .formkit-spinner {
      opacity: 1;
      height: 100%;
      width: 50px;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-submit[data-active] .formkit-spinner~span {
      opacity: 0;
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-powered-by[data-active="false"] {
      opacity: 0.35;
    }

    @-webkit-keyframes formkit-bouncedelay-formkit-form-data-uid-8bc636d501- {

      0%,
      80%,
      100% {
        -webkit-transform: scale(0);
        -ms-transform: scale(0);
        transform: scale(0);
      }

      40% {
        -webkit-transform: scale(1);
        -ms-transform: scale(1);
        transform: scale(1);
      }
    }

    @keyframes formkit-bouncedelay-formkit-form-data-uid-8bc636d501- {

      0%,
      80%,
      100% {
        -webkit-transform: scale(0);
        -ms-transform: scale(0);
        transform: scale(0);
      }

      40% {
        -webkit-transform: scale(1);
        -ms-transform: scale(1);
        transform: scale(1);
      }
    }

    .formkit-form[data-uid="8bc636d501"] .formkit-submit {
      width: 100% !important;
      margin: 10px 0;
    }
  </style>
</form>

POST https://chandoo.org/wp/wp-comments-post.php

<form action="https://chandoo.org/wp/wp-comments-post.php" method="post" id="commentform">
  <p><input class="TextField" style="width: 210px;" type="text" name="author" id="author" value="" size="22" tabindex="1" aria-required="true">
    <label for="author"><small>Name (required)</small></label>
  </p>
  <p><input class="TextField" style="width: 210px;" type="text" name="email" id="email" value="" size="22" tabindex="2" aria-required="true">
    <label for="email"><small>Mail (will not be published) (required)</small></label>
  </p>
  <p><input class="TextField" style="width: 210px;" type="text" name="url" id="url" value="" size="22" tabindex="3">
    <label for="url"><small>Website</small></label>
  </p>
  <!--<p><small><strong>XHTML:</strong> You can use these tags: <code>&lt;a href=&quot;&quot; title=&quot;&quot;&gt; &lt;abbr title=&quot;&quot;&gt; &lt;acronym title=&quot;&quot;&gt; &lt;b&gt; &lt;blockquote cite=&quot;&quot;&gt; &lt;cite&gt; &lt;code&gt; &lt;del datetime=&quot;&quot;&gt; &lt;em&gt; &lt;i&gt; &lt;q cite=&quot;&quot;&gt; &lt;s&gt; &lt;strike&gt; &lt;strong&gt; </code></small></p>-->
  <p><textarea name="comment" id="comment" cols="100%" rows="10" tabindex="4" class="Textarea" style="border: 1px solid #000000; width: 450px;"></textarea></p>
  <p><input name="submit" type="submit" id="submit" tabindex="5" value="Submit Comment" class="Cbutton">
    <input type="hidden" name="comment_post_ID" value="712" id="comment_post_ID">
    <input type="hidden" name="comment_parent" id="comment_parent" value="0">
  </p>
  <p style="display: none;"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="bae1560a54"></p>
  <p style="clear: both;" class="subscribe-to-comments">
    <input type="checkbox" name="subscribe" id="subscribe" value="subscribe" style="width: auto;">
    <label for="subscribe">Notify me of when new comments are posted via e-mail</label>
  </p>
  <p style="display: none !important;"><label>Δ<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js_1" name="ak_js" value="1689611798862">
    <script>
      document.getElementById("ak_js_1").setAttribute("value", (new Date()).getTime());
    </script>
  </p>
</form>

Text Content

* Home
* About
* All posts
* Contact
* Ask a question

Login to online classes
* Start Here
* Blog
* Classes
* Excel School
* VBA Classes – Learn VBA Macros today
* Power BI Play Date
* 50 Ways to Analyze your Data
* Mini-Courses
* Power BI Remote Training Options
* Videos
* Intro to Excel
* Writing Formulas
* … more
* Topics
* Excel Basics
* Advanced Excel Skills
* Learn Power BI
* Power Query Tutorial
* Excel Pivot Tables – Full guide
* Project Management using Excel
* Formulas
* Tables & Structural Refs
* IF
* CHOOSE
* XLOOKUP
* SUMIFS
* SUBTOTAL
* INDEX
* VLOOKUP & other lookups
* 100+ Formula Examples
* Multi-condition lookups
* Array formulas
* Top 10 formulas
* Dashboards
* What are they, how to make one?
* Dynamic Dashboard in Excel
* Customer Service Dashboard
* 200+ Examples
* Dashboard Training Course
* Charts
* VBA
* 40+ Examples
* More on VBA
* Resources
* 100s of FREE Excel Templates
* Resources for Freelancers
* Mini-Courses

Menu
* Start Here
* Blog
* Classes
* Excel School
* VBA Classes – Learn VBA Macros today
* Power BI Play Date
* 50 Ways to Analyze your Data
* Mini-Courses
* Power BI Remote Training Options
* Videos
* Intro to Excel
* Writing Formulas
* … more
* Topics
* Excel Basics
* Advanced Excel Skills
* Learn Power BI
* Power Query Tutorial
* Excel Pivot Tables – Full guide
* Project Management using Excel
* Formulas
* Tables & Structural Refs
* IF
* CHOOSE
* XLOOKUP
* SUMIFS
* SUBTOTAL
* INDEX
* VLOOKUP & other lookups
* 100+ Formula Examples
* Multi-condition lookups
* Array formulas
* Top 10 formulas
* Dashboards
* What are they, how to make one?
* Dynamic Dashboard in Excel
* Customer Service Dashboard
* 200+ Examples
* Dashboard Training Course
* Charts
* VBA
* 40+ Examples
* More on VBA
* Resources
* 100s of FREE Excel Templates
* Resources for Freelancers
* Mini-Courses

Search
Search
Close this search box.
* Charts and Graphs, hacks, ideas, Learn Excel, technology

CREATING IN-CELL BAR CHARTS / HISTOGRAMS IN EXCEL

* Last updated on May 13, 2008

CHANDOO

Facebook
Twitter
LinkedIn

Ever since writing the create in-cell pie charts in excel, I have been itching
to find a simple enough method to do incell bar graphs. An in-cell bar would
probably be more useful and cuter than an in-cell pie as it can instantly
provide trending details. What more, these would probably look gorgeous when
printed out.

My first challenge was that there was no font readily available for bar graphs.
Thankfully this is when I noticed Font Struct, an online font creator / editor.
I quickly created a bar graph font using their wonderful editor. When you use
bargraph font, 0 through 9 will show bars of increasing heights, as shown below.

You should download bargraph font if you want to use incell bar graphing
technique mentioned here.

Once you have downloaded the font, the rest is simple process. For this example,
lets use fictitious sales data of various beverages over the last 12 months. The
initial data table is something like this:

1. First we will insert a column next to the total sales column and call it
“last 12 months”. We will use this column to fill up the in-cell bar graph
for the last 12 month sales.
2. Next we need to normalize the sales values for each month to a value between
0 to 9. I have used linear normalization, ie the maximum value across the 12
months would be 9 and everything else will be normalized according this. The
formula for one month looked something like this:
=ROUND(jan_sales/MAX(all_sales)*9,0). Remember, we need to round the data
make it one digit instead of a decimal.
3. Once we have normalized values for each of 12 sales figures for each row, we
just need to concatenate them to create a 12 character long string of
numbers and place this values in our newly inserted column
4. Finally, we will change the font of this column to “bargraph” (just select
all the cells under the “last 12 months” and change the font)

When we are finally done, our table should look something like this:

5. Thats all, we now have a charming data table with cute little incell bar
graphs to insert your project report / sales memo or news letter.

--------------------------------------------------------------------------------

Feel free to download example excel sheet I have created and learn how to do
in-cell bar graphs

--------------------------------------------------------------------------------

Remember, you need to have the bargraph font installed first.

Do you like this? share your feedback.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

GET FREE EXCEL + POWER BI TIPS

Simple, fun and useful emails, once per week.

Learn & be awesome.

You want to learn
Excel
Power BI

* 56 Comments
* Ask a question or say something...
* Tagged under Charts and Graphs, cool, howto, ideas, in-cell charting, Learn
Excel, microsoft, MS, technology, tips, tricks
* Category: Charts and Graphs, hacks, ideas, Learn Excel, technology

PrevPreviousShootout @ Hocking hills state park

NextMPDNext

WELCOME TO CHANDOO.ORG

Thank you so much for visiting. My aim is to make you awesome in Excel & Power
BI. I do this by sharing videos, tips, examples and downloads on this website.
There are more than 1,000 pages with all things Excel, Power BI, Dashboards &
VBA here. Go ahead and spend few minutes to be AWESOME.

Read my story • FREE Excel tips book

Want an AWESOME
Excel Class?

Excel School made me great at work.
 5/5

– Brenda

FREE Goodies for you...

100 Excel Formulas List

From simple to complex, there is a formula for every occasion. Check out the
list now.

20 Excel Templates

Calendars, invoices, trackers and much more. All free, fun and fantastic.

13 Advanced Pivot Table Skills

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and
beautiful charts. It's all here.

Get started with Power BI

Still on fence about Power BI? In this getting started guide, learn what is
Power BI, how to get it and how to create your first report from scratch.