Creative Grid Chart to Show Most Busy Time in Excel 365
Tags: creativegridcharttos
Published: 2021-08-19 04:50:25

---
title: Creative Grid Chart to Show Most Busy Time in Excel 365
published: true
date: 2021-08-11 16:54:17 UTC
tags: CreativeGridChartToS
canonical_url: https://geekexcel.com/creative-grid-chart-to-show-most-busy-time-in-excel-365/
---

Have you ever tried **a Creative Grid Chart To Show Most Busy Time In Excel 365**? Do you have any good methods for solving this task in Excel? Here I will introduce you to some quick tricks to deal with this problem. 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)

## Set the Colors

- Firstly, you have to **create the table with data**.
- For instance, we have shown the **list of visitors** below.

![](https://geekexcel.com/wp-content/uploads/2021/08/List-of-visitors.png)<figcaption>List of visitors</figcaption>

- Then, you need to **select the data** range **B3:E10** and do not select the **headers**.

![](https://geekexcel.com/wp-content/uploads/2021/08/select-the-Range.png)<figcaption>Select the Range</figcaption>

- Now, you have to go to the **Home** and then click **Conditional Formatting** and select **Color Scales**.

![](https://geekexcel.com/wp-content/uploads/2021/08/choose-color-scales-1024x530.png)<figcaption>Click Color scales</figcaption>

- After that, you will be shown **some default color scales** to be used **directly**.
- Here, if you want to **use the Dark and Light Blue combination** which is not in **default options** , you have to click on **More Rules**.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-More-Rules.png)<figcaption>Click the More Rules option</figcaption>

- Then, in the **More Rules** option, you have to see the **Format Style** option.
- Now, you need to choose the **3-Color Scale** option.
- After that, for the **Lowest Value** , you have to choose a **light blue**  **color**.
- You need to choose a **fair blue color** for **Midpoint**.
- Now, you have to choose a **dark blue color** for the **Highest Value**.

![](https://geekexcel.com/wp-content/uploads/2021/08/set-the-colors.png)<figcaption>To set color</figcaption>

- Finally, you need to hit **OK** button to get the result.

![](https://geekexcel.com/wp-content/uploads/2021/08/final-output.png)<figcaption>After hitting the OK button</figcaption>

## Make the text invisible

- Firstly, the **chart** is almost ready, but we have the **numbers visible** yet.
- Then, you need to make the chart **invisible**.
- Now, you have to **select the data** range **B3:E10** and press **Shift+F10** shortcut to **open cell formatting**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-Format-cells.png)<figcaption>Click format cells</figcaption>

- After that, on the **numbers** tab, you have to click on the **custom** option.
- Then, at the place of **General** , you have to write **three semicolons** **(‘;;;’)**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Select-Custom-option.png)<figcaption>Write three semicolons</figcaption>

- Now, you need to hit **OK** button to get the **invisible** results.

![](https://geekexcel.com/wp-content/uploads/2021/08/invisible-results.png)<figcaption>Invisible results</figcaption>

## Format the Grid to Make this Chart More Elegant

- You need to **select the range** , go to **Home** and in the **Font** section, you have to click **Borders** option.
- Then, you have to select **Line Color** option and choose a **white color**.

![](https://geekexcel.com/wp-content/uploads/2021/08/choose-line-color.png)<figcaption>Choose Line color</figcaption>

- Now, you need to **apply this border** on the **whole** table and **remove Extra formatting**.

![](https://geekexcel.com/wp-content/uploads/2021/08/line-color-white.png)<figcaption>Line color-White</figcaption>

## Bottom-Line

In this tutorial, we guided you to know how to **use Creative Grid Chart To Show Most Busy Time In Excel 365** with proper examples and screenshots. Kindly, give your **feedback** in the below comment section.

Thanks 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 Also:**

- **[Simple Shortcuts for Grid Options in Microsoft Excel 365!!](https://geekexcel.com/simple-shortcuts-for-grid-options-in-microsoft-excel-365/)**
- **[Toggle All Hidden Columns to be Visible or Invisible in Excel 365!!](https://geekexcel.com/toggle-all-hidden-columns-to-be-visible-or-invisible-in-excel-365/)**
- **[Toggle All Hidden Sheets to be Visible or Invisible in Excel Office 365!!](https://geekexcel.com/toggle-all-hidden-sheets-to-be-visible-or-invisible-in-excel-office-365/)**
- **[Change the Chart Type in Excel Office 365 ~ With Clear-Cut Examples!!](https://geekexcel.com/change-chart-type-excel/)**