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

*Conditional Formatting***Table of Contents**Expand

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

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 Bar**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
*New Formatting Rule**dialog box*will pop up. - 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 defined the maximum value as*Data Bars*.*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 the
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: **Conditional Formatting with Data Bars Based on Another Cell in Excel

### 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: **How to Add Data Bars in Excel

### 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 the
:*Maximum Value***50**. - Lastly, press
.*OK*

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

**Read More: **How to Use Data Bars with Percentage in Excel

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

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

**to set the maximum**

*Formula***Data Bar**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 sets 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 the
:*Maximum Value***90**. - Lastly, press
.*OK*

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

**Read More: **[Fixed]: Conditional Formatting in Data Bar Percentage Not Working in Excel

## Practice Section

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

**Download Practice Workbook**

## 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. Thanks for reading, keep excelling!

## Related Articles

- How to Add Solid Fill Data Bars in Excel
- How to Add Blue Data Bar in Excel
- How to Remove Data Bars in Excel
- [Solved]: Data Bars Not Working in Excel

**<< Go Back to Data Bars | Conditional Formatting | Learn Excel**