can bar charts only show right side not matter it is negative or positive value?

**[kinder]** · 08-23-2018, 02:33 PM

because normally the charts will show on left side when value is negative and positive will be show on right side.
can bar charts only show right side not matter it is negative or positive value?(all show on right side and label the value)

Thanks and regards,
Kinder.

**dflak** · 08-23-2018, 02:55 PM

It would seem that if you plotted a helper column that has the formula: =ABS(Value) you would get what you want.

You might even want to separate the positive and negative numbers into two series and plot them as black and red (or colors of your choice) as a conditional bar chart. This link explains how to do that: https://peltiertech.com/conditional-...-excel-charts/.

**[kinder]** · 08-24-2018, 03:07 AM

i go through the line that your given,but the expect outcome is like it will just show a side and label it is negative or positive.

the attached image is taken from the link ,but not the expected outcome,the expected outcome is like the bar only show one side and label it is positive or nagetive value.