Charts with floating up-down bars in Excel 365 – Easy Tricks!!
Tags: chartswithfloatingup
Published: 2021-08-07 06:17:09

---
title: Charts with floating up-down bars in Excel 365 – Easy Tricks!!
published: true
date: 2021-08-06 12:01:20 UTC
tags: ChartsWithFloatingUp
canonical_url: https://geekexcel.com/charts-with-floating-up-down-bars-in-excel-365-easy-tricks/
---

Have you ever tried **Charts With Floating Up-Down Bars In Excel 365?** Here we will show the simple formulas to solve this problem. Let’s dive into this article! 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)**

## Use Floating Up-Down Bars

Here we have data on the Price distribution of Cars to compare their price with each other. Follow the steps below, which will guide you through the chart step by step.

- Firstly, you have to **create the table with data**.
- For instance, we have shown the **data of Price distribution of Cars** to compare their price with each other.

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

- Then, you have to click on the **Insert** tab.
- Now, you need to **choose type of charts** under the **[Chart](https://geekexcel.com/create-bar-charts-in-excel-office-365-simple-easy-steps/)**section.
- After selecting the **chart type** , you will see the list of items in the **chart format**

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

- You need to click on the **plus sign** on the top right of the chart.

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

- Then, you need to click the  **Up/Down bars**  option. This feature will represent the data range as bars as shown below.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-up-down-option-1024x353.png)<figcaption>Click the Up/Down bars</figcaption>

- Now, you have to **fill the chart** with **color** by **double-clicking on bars** and the **Format Up bars panel** will appear on the right of the sheet.

![](https://geekexcel.com/wp-content/uploads/2021/08/Format-up-bars.png)<figcaption>Format up bar panel</figcaption>

- After that, you need to **fill up bars** with different **texture or color** from this panel.

![](https://geekexcel.com/wp-content/uploads/2021/08/fill-color-and-texture.png)<figcaption>Fill the color and texture</figcaption>

- Then, you need to **edit the lines** in the chart.
- For that, you have to **double-click** the **orange line** and select the  **No line**  option from the  **Format Data Series ** panel.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-no-line-option.png)<figcaption>Click on the No Line option</figcaption>

- At last, if required, you can perform the **same task for the other line**.

## Wrap-Up

From this tutorial, you can get some clarification on **Charts With Floating Up-Down Bars In Excel 365**. If you have any other **ideas** or **question** , do share with us here in the **comment’s** section below.

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/) **!!**