Looking for ways to **define maximum Data Bars value** in **Excel**? Then this is the right article for you. ** Data Bar** is a

**feature inside**

*Conditional Formatting***Excel**that gets larger for more extensive data. We use this to compare data against other data in

**Excel**. In this article, we will show you

**6**easy methods to

**define maximum Data Bars value**in

**Excel**.

**Table of Contents**hide

## Download Practice Workbook

## 6 Handy Approaches to Define Maximum Data Bars Value in Excel

To demonstrate our methods, we have selected a dataset with **3 **columns: “**Name**”, “**Sales**”, and “**Data Bars**”. We have used the sales data to create a “*Data Bar**” *and we will set the **maximum value **using **6 **options.

### 1. Define Maximum Data Bars Value in Excel Automatically

For the first method, we will use the ** Automatic **feature to define the

**maximum Data Bars value**in

**Excel**.

- To begin with, copy all the sales values into the next column.

- Then, select the cell range
.*D5:D10* - Next, from the
**Home**tab >>>>>> select “*Conditional Formatting*”.*New Rule…*

- So, the
will pop up.*New Formatting Rule dialog box* - Then, select
from the*Data Bar*box.*Format style* - Afterward, select
. This will hide the numbers from the*Show Bar Only*.*Data Bars* - Then, under the
, select*Maximum*as the*Automatic*.*Type* - Optionally, you can change the
using*Bar Appearance*and*Fill*.*Border color* - After that, press
.*OK*

- So, our
will look like this.*Data Bars*

- Additionally, we can add preset to the
.*Data Bars* - To do so, select the
.*Data Bars* - Then, from the
tab >>>*Home*>>>*Conditional Formatting*>>> select the*Data Bars*preset.*Orange Data Bar*

- Lastly, our
will look like this and we have*Data Bars***defined**the**maximum value**as.*Automatic*

**Read More:** **Conditional Formatting Data Bars Different Colors**

### 2. Using Highest Value to Define Maximum Data Bars Value in Excel

For the second method, we will use the ** Highest Value** option to

**define**the

**maximum Data Bars value**.

- Firstly,
**as shown in the first method**, we have shown the.*Data Bars* - Next, select the cell range
.*D5:D10* - Then, from the
tab >>>*Data*>>> select*Conditional Formatting*.*Manage Rules*

- After that, the “
” box will appear.*Conditional Formatting Rules Manager* - Then, double-click on the
.*Data Bar Rule*

- So, another
will pop up.*dialog box* - Then, select
from the*Highest Value*.*Maximum Type* - Lastly, press
.*OK*

- Thus, we will change the
**maximum Data Bars value**in**Excel**and the final step will return this result.

**Read More:** **How to Add Data Bars in Excel (2 Easy Methods)**

### 3. Applying Number to Define Maximum Data Bars Value

For the third method, we will set a ** Number **manually to

**define**the

**maximum Data Bars value**.

**Steps:**

- Firstly,
**as shown in the first method**, we have shown the.*Data Bars* - Then,
, we bring up the*similar to the second method*.*Edit Formatting Rules dialog box* - Next, select
:*Maximum Type*.*Number* - After that, set
:*Maximum Value***50,000**. - Lastly, press
.*OK*

- So, the final output will be this.

**Read More:** **[Solved]: Data Bars Not Working in Excel (3 Possible Solutions)**

### 4. Define Maximum Data Bars Value in Excel Using Percent

For the fourth method, we will use ** Percent **to set the

**maximum Data Bars value**.

**Steps:**

- Firstly,
**as shown in the first method**, we have shown the.*Data Bars* - Then,
, we bring up the*similar to the second method*.*Edit Formatting Rules dialog box* - Next, select
:*Maximum Type*.*Percent* - After that, set
:*Maximum Value***50**. - Lastly, press
.*OK*

- So, the final output will be this as shown in the image below.

### 5. Define Maximum Data Bars Value Applying Formula

For the fifth method, we will use ** the SUM function** to create a

**to set the**

*Formula***maximum Data Bars value**in

**Excel**.

**Steps:**

- Firstly,
**as shown in the first method**, we have shown the.*Data Bars* - Then,
, we bring up the*similar to the second method*.*Edit Formatting Rules dialog box* - Next, select
:*Maximum Type*.*Formula* - After that, set
: type this formula from below.*Maximum Value*

`=SUM($D$5:$D$10)`

- This formula set the
**Data Bars**as the proportion of the total sales amount. - Lastly, press
.*OK*

- Hence, the final output will be this.

### 6. Using Percentile to Define Maximum Data Bars Value

For the last method, we will use the ** Percentile **feature to set the

**maximum Data Bars value**.

**Steps:**

- Firstly,
**as shown in the first method**, we have shown the.*Data Bars* - Then,
, we bring up the*similar to the second method*.*Edit Formatting Rules dialog box* - Next, select
:*Maximum Type*.*Percentile* - After that, set
:*Maximum Value***90**. - Lastly, press
.*OK*

- Consequently, the modified
will be like this.*Data Bars*

## Practice Section

We have added a practice dataset for each method in the **Excel** file. Therefore, you can follow along with our methods easily.

## Conclusion

We have shown you **6** handy approaches to how to **define maximum Data Bars** **value **in **Excel**. If you face any problems regarding these methods or have any feedback for me, feel free to comment below. Moreover, you can visit our site **ExcelDemy** for more **Excel-related** articles. Thanks for reading, keep excelling!