Conditional Formatting Data Bar Axis

**ptrling** · 12-11-2014, 11:59 AM

So currently the bars for conditional formatting have '0' as the y axis value, so any values below this, the bar goes to the left as opposed to the right. I'm trying to set '100' as my middle value so that any values beneath that (down to 0) go to the left, and any above 100 (up to 200) go to the right hand side,

Is there any way of doing this in conditional formatting data bars?

Thanks,

**newdoverman** · 12-11-2014, 12:00 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**Andy Pope** · 12-11-2014, 12:07 PM

You can only change it's position relative to the cell midpoint, you can change it position by value.

You would need to use a helper column to display bars based on recalculated values.

**ptrling** · 12-11-2014, 01:30 PM

Conditional Formatting Test.xlsx Conditional Formatting Test.xlsxAttachment here

**ptrling** · 12-16-2014, 07:03 AM

Any suggestions?

**newdoverman** · 12-16-2014, 10:15 AM

You have two different things here. On the left you have data bars produced by conditional formatting and on the right you have a bar chart. They are two different things. The data bars cannot be formatted like the bar chart and visa versa. The just isn't the facility built into the Data Bars to do what you are wanting.