KB18227: Bar graph displays on the positive axis when all the metric values are negative in MicroStrategy Developer 9.x and 10.x

SYMPTOM:
A report is run as a clustered bar graph in Strategy Developer 9.x and 10.x. The bars display on the positive axis although the values are negative, as shown below:
 

 
STEPS TO REPRODUCE:
Follow the steps below to reproduce this issue:
 

• Create one metric that consists only of negative values. The example below is from the Strategy Tutorial project using the Cost metric and multiplying it by -1.
  

• Add the new metric with one attribute to report. In the example below, the Month attribute was used.
  

• Run this as a Clustered Bar Graph. The results will appear with 0 at the first value of the graph as shown below:
  

CAUSE:
This is a known issue in Strategy Developer 9.x and 10.x.
 
ACTION:
Change the bar graph type to Stacked. To do this, right click the graph and select 'Graph Options'. Select the Layout tab and choose 'Stacked' as shown below.