Excel Formulas to Find Basic in cell histogram in Excel!!
Tags: excelformula, excelformulas
Published: 2021-11-01 11:08:06

---
title: Excel Formulas to Find Basic in cell histogram in Excel!!
published: true
date: 2021-10-30 09:19:32 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-basic-in-cell-histogram-in-excel/
---

So far we have learned the formulas to **[test all cells in a range are blank or empty in Excel](https://geekexcel.com/excel-formulas-test-all-cells-in-a-range-are-blank/)**. Likewise, here we are going to ** find the basic in-cell histogram in Excel**   **365**. Let’s get them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Generic Formula

- Use the below given formula to find the basic in-cell histogram.

```
=[REPT](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/)(barchar,value/100)

```

## Syntax Explanation

- **Comma symbol (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **REPT** – The **[REPT function](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/)** repeats characters a given number of times.

## Practical Example

- For instance, you have to **create a sample data** in Excel.

![](https://geekexcel.com/wp-content/uploads/2021/10/Sample-data-75.png)<figcaption>Sample data</figcaption>

- To create a **simple in-cell histogram** , you need to use a formula given below in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=[REPT](https://geekexcel.com/how-to-use-rept-function-in-microsoft-excel-2013/)([CHAR](https://geekexcel.com/how-to-use-char-function-in-microsoft-excel-365/)(110),C11/100)

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Use-the-Formula-28.png)<figcaption>Use the Formula</figcaption>

- Finally, you have to **Hit the Enter key** to get the result as in-cell histogram.

## Wind-Up

So yeah guys this is how you can ** find the basic in-cell histogram in Excel 365**. Hope you like this article. If you have any  **questions** , feel free to  **comment**. Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Next:**

- **[Excel Formulas: Histogram with Frequency in Office 365!!](https://geekexcel.com/excel-formulas-histogram-with-frequency-in-office-365/)**
- **[Create a Histogram Chart in Excel Office 365 with an Example!!](https://geekexcel.com/create-a-histogram-chart-in-excel-office-365-with-an-example/)**
- **[Excel Formulas to Find the First Column Number in a Range ~ Easily!!](https://geekexcel.com/excel-formulas-to-find-the-first-column-number-in-a-range/)**
- **[How to show all Formulas in Excel Office 365 ~ With Examples!!](https://geekexcel.com/show-all-formulas-in-excel/)**
- **[Excel Formulas to Find the Last Column Number in a Range ~ Quickly!!](https://geekexcel.com/excel-formulas-to-find-last-column-number/)**