Horizontal Bar Graph

[sirchambo]

I saw a similar question, but not quite the same.

I'm in need of the ability to set or change the default "zero" value for horizontal bar graphs. Currently Excel will plot horizontal bar graphs either to the right or left of the zero, thus your positive values are to the right and negatives to the left. I cannot seem to find a way to alter the reference point for where bar graphs originate from - eg, I'd like to set the median value of the bar graph and display the horizontal bars accordingly.

Thanks in advance.

[Andy Pope]

Double click the Value axis and on the Scale tab change the value of "Category(X) axis crosses at" to required median value.

[sirchambo]

Thanks Andy. Problem solved!